the results for
select * from sys.indexes where object_id=1591012749
name index_id
[font="Courier New"]PK_EXAMPLEUsers 1 CLUSTERED1
IX_EXAMPLEUsers_clientid 7 NONCLUSTERED0
_dta_index_EXAMPLEUsers_9_1591012749__1K 8 NONCLUSTERED0
_dta_index_EXAMPLEUsers_9_1591012749__2K 14 NONCLUSTERED0
_dta_index_EXAMPLEUsers_9_1591012749__3K 15 NONCLUSTERED0
_dta_index_EXAMPLEUsers_9_1591012749__4K 16 NONCLUSTERED0
_dta_index_EXAMPLEUsers_9_1591012749__5K 18 NONCLUSTERED0
_dta_index_EXAMPLEUsers_9_1591012749__6K 20 NONCLUSTERED0[/font]
i don't see index_id 22 which was specified in the dbcc results
does this mean the table itself needs to be recreated?
thanks