I've setup the reindex jobs in SSMS Maintenance plans and also tried to reindex with right click table indexes and Reindex all so far. The individual indexes frag % drops when viewed in SSMS right click index-> properties, but no joy in the lowering of % reported in the query from my original post. I've also made sure to update statistics before rechecking the query from my original post. Thanks