[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 898
  • Last Modified:

indid = 255 and impid = -1

I have a few indexes from an inherited database that have the values in the sysindexes table of impid = -1 and indid = 255.  The names of the indexes are not in the table itself.  Were these indexes that had been dropped?  What does indid = 255 mean?  what does impid = -1 mean?
0
KathleenR
Asked:
KathleenR
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>What does indid = 255 mean?  
Indid 255 are holders in sysindexes for text, ntext and image data.

>Were these indexes that had been dropped?  
no

>what does impid = -1 mean?
column impid = -1 has no meaning for these
0
 
KathleenRAuthor Commented:
so how is it these indexes are in the sysindexes table but when I go to manage indexes on the table they are not there or when I try to do a dbcc indexdefrag the command errors on those index names?

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
they are not normal indexes, as said they are system (internal) indexes. they are to keep the correlation between the table rows and the text, ntext and image data which are not inline with the rows on the same pagees, but on other pages.
you don't need to dbcc indexdefrag those, simply ignore them
0
 
Gautham JanardhanCommented:
select sysobjects.name,sysindexes.name, * from sysindexes, sysobjects where sysindexes.id = sysobjects.id
and xtype = 'u'

this will give u the name of the table or view which is indexed
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now