Question Regarding Index

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Question Regarding Index

Question Regarding Index

Rate Topic

Display Mode

Topic Options

Author

Message

Lester Policarpio

Posted Wednesday, January 30, 2008 6:14 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 6:45 PM
Points: 398, Visits: 2,405

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

Edward-445599

Posted Thursday, January 31, 2008 9:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:43 AM
Points: 174, Visits: 435

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 »

Permissions