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

Question Regarding Index Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 6:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:06 PM
Points: 398, Visits: 2,428
Hi i was given a task to re-index indexes in some tables. To spot if a table has an index i run sp_helpindex for every tables and it gave me a result 3 out of 5 and displayed the index name. Then i created a job shedule to run this re-index every after office hours starting last day. But when i checked it a while ago it failed stating that tha table has no index but sp_index says it has? I then went to enterprise Manager, all task, manage Index and saw nothing in the index section for all the tables in that database. Is this possible?? what can be the explanation to this? thanks in advance

"-=Still Learning=-"

Lester Policarpio

Post #449766
Posted Thursday, January 31, 2008 9:35 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:35 AM
Points: 193, Visits: 504
just look at the clustered indexes. what did this phantom index start with. if it was hind it is a hypothetical index which sql has created. Generaly I delete them, if you do not know what a HIND index is look it up (fairly simple). PS dont forget the stats
Post #450036
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse