Djblois
08-12-2010, 11:32 AM
Should I use a sort in my tables or should i leave it alone? would it be slower since the tables sort by one thing then a query sorts by another? If I do sort - should it be sorted by the primary key or the foreign key when applicable?
Don't bother setting a sort on the tables. You can use one in a QUERY but setting a sort in the table really does not help anything. It is only really setting the sort of the VIEW when you open a table (which is not really opening the table but in reality is opening a special type of query).
Djblois
08-12-2010, 11:37 AM
So would it help me any to remove the sorts?