Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Clustered Index Scan is taking 87% in executation plan RE: Clustered Index Scan is taking 87% in executation plan

  • December 19, 2012 at 5:27 am

    #1570008

    1. How many records the table has and what kind of table it is i.e. means read only or having lots of DML operations.

    2. What is the fill factor for the index ?