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: Today @ 12:34 AM
Points: 132, Visits: 429
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 @ 8:49 PM
Points: 17,967, Visits: 15,979
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: 2 days ago @ 8:12 AM
Points: 7,135, Visits: 12,746
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