January 30, 2008 at 6:14 pm
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
January 31, 2008 at 9:35 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply