• Customer would fire insert,update,select queries most of the time. Most of the tables have clustered index and some of them have combination of (clustered)+ (non-unique,non-clustered indexes).

    Statistics are up to date. Fragmentation percent before rebuild is close to 50% for some tables and 0% for some tables.