Posted by Enorme Vigenti on 11/09/07 08:52

I have a large table with an unique integer primary key and many coloums
I have various programs to calculate many satistical information, this
programs use many stored procedures.
In other words many select statement query on the same table with where
clause on all combinations for the coloums.
Now I must create index
Initially i was create cluster primary key and many index on datatime
field and one other coloumn
But now I ask: If I create an index with all coloumns, it is used by
sqlserver for speed the query who use only 1, or 2 coloumns only?
....and it is better to make this index clustered (and not the primary key?)
I'm reading various sqlserver manual to know the index policy but I
can't to understand how to do this!!!
Can anyone to help me?
tnx

[Back to original message]