Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Clustered Index Scan is taking 87% in executation plan Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 5:10 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 6:34 AM
Points: 953, Visits: 246
Hi All,

My Clustered Index Scan is taking 87% in executation plan.
can you please suggest me to how to reduce this and improve the perforance.
Post #1398326
Posted Wednesday, December 19, 2012 5:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:30 AM
Points: 78, Visits: 195
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 ?
Post #1398329
Posted Wednesday, December 19, 2012 5:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:58 PM
Points: 42,466, Visits: 35,532
First thing. Is that query a problem?
The percentages in the plan must add up to 100%, so the fact that a scan is 87% is not necessarily a problem.

If the query is a problem, then please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1398340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse