• Just be careful with how/where the 1000 page count is checked. I've reviewed a few automated optimisation routines, and a lot of them check the page count at the index level, not at the data level. When this happens we get tables well over 1000 pages, but with small indexes not being optimised, and I've seen poor performance as a result.

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.