• As general thumb rule most experts agree having the table or index greater than 10000 pages de-fragmentation improves performance lesser , table scan is a effective as non clustered index seek for < 10K pages

    There little performance impact for lesser than 10000 data pages.

    Cheers

    Sat

    Cheer Satish 🙂