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

Missing index statistics - Dementia ? Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 9:58 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 8, 2015 2:41 AM
Points: 133, Visits: 432
I use a script showing me the missing index statistics with impact and so on. I think you all know it. But sometimes I add an index which is costly, cleanup the statistics. And he shows me the index again? Why this? IS this a bug? Can somebody explain me this? Getting into details would be nice ;).

PS: I know the impact is not a good indicator, but what is the reason for this behaviour?


Greetz
Query Shepherd
Post #1429363
Posted Monday, March 11, 2013 10:37 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 4:48 PM
Points: 18,186, Visits: 16,241
Sometimes you may continue to see that index because the query that needs it has columns using a different sort order than the index. And sometimes it is a bug.

First check the sort for the columns and see if that is impacting the index use.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1429393
Posted Tuesday, March 12, 2013 5:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, January 19, 2015 6:47 AM
Points: 7,157, Visits: 12,778
The bug.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1429695
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse