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 🙂