November 4, 2014 at 5:28 am
HI,
I Had a table with 8 columns ,
I had one cluster index on one column, so i want to create composite cluster index on all columns
does it improve any performance or not ?
Thanks
November 4, 2014 at 5:41 am
It might be, depending on the queries.
It might as well not. Typically you want your clustered index to be unique (selective) and narrow.
What kind of performance issues do you have?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 4, 2014 at 5:44 am
actually some SP are getting lots of time to execute so if i create a composite cluster index with all columns then it will improve or need to create non cluster index individual with including all columns which will improve??
November 4, 2014 at 5:48 am
santoshkal (11/4/2014)
actually some SP are getting lots of time to execute so if i create a composite cluster index with all columns then it will improve or need to create non cluster index individual with including all columns which will improve??
It's hard to say without taking a look at the table DDL and the queries involved.
Do the query plans indicate that there are missing indexes?
There is no silver bullet that will solve all of your performance problems at once.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply