>I am looking for a few simple arguments why a table should have its own unique index and when setting order should not be: "set order to field1,field2".
>Anyone? Thanks.
Jim,
Your question is a bit confusing. What do you mean by, "It's own unique index"? SET ORDER requires that indexes exist, so that is where the confusion is coming from.
Can you rephrase the question for us?