General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only