Sort Index Normal

[#1]

Turning on Sort Index before Importing the data is it a Good Practise?, Does it make the Import a Lot Slower, On Average for a main Table of 200 fields what should be the critical Number for Sort Index fields count before the system starts to break down?

Ideally shouldn't the Indices be updated only when we Load the server "Update Indices" way and not affect an Import?

-Sudhir

[Former Member]

For now I am assuming Sort Index is like Query performance tuning and should be turned-on on a need basis after entire data Load.

Thanks for your replies