>I have a SQL Server table that has 7 indexes defined. When I do a simple select
>statement from the query analyzer without using ORDER BY the results of the query come back in the order of the 4th index defined. Is there a way to define
>an index as primary in SQL server either with a command or using the enterprise manager ?
>
>Thanks For Your Help !
>Stephen J. Hunt
>Admit Computer Services Inc.

Set the index as CLUSTERED and add ORDER BY to declare the order,
but it is not said that this is a good choice.