Yuri55 (1/6/2013)
Thanks guys for all your answers-just to summarize- for index maintenance we need to take into account both logical fragmentation and page density. Still have couple questions left:
1) index size 1000+ pages recommendation for any action- valid for ReBuild and ReOrganize?
If it is below 1000 pages chances are index maintenance will not make much difference so most of the scripts out there skip those smaller indexes regardless of the fragmentation level.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato