Sunil Kanta (9/24/2009)
Exactly, I could later manage to reorder for PK index. And I did this only because i got a error while moving.But, what for Non-Clustered Composite Index? I din't get any error and it moved sucessfully. I am worried about the indexed column order now. Does it gonna effect db performance?
Regards,
Sunil
That will depend on the actual data content ( cardinality and organisation ) and the way your queries use the source object !
One should not modify and indexes column order if one doesn't have performance reasons to do so !
In a unique index, one should compose the columns only for performance ! (filter factors, usage,..)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me