- With aligned indexes, sql will take the most advantage of the mechanisme when querying partitioned objects. (because the indexes will basically have the same algorithm applied internally, so in stead of being one big index, the aligned index will itself be physically split into the number of partitions you have ! )
- To enable partition switching, all indexes on the table must be aligned.
- BOL has good info ! topic "Special Guidelines for Partitioned Indexes "
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