I am running into an issues with locating index

In SSMS, if I expand Users>Indexes, I do not see an index named "_dta_index_Users_5_1466188719_88410000_K1_K6_K2_7_10_11"

But I can see a statistics created for it.

Also when I search for indexes on "Users" by running this query

SELECT index_id, name FROM sys.indexes WHERE object_id = OBJECT_ID('Users')

It appears in the result "_dta_index_Users_5_1466188719_88410000_K1_K6_K2_7_10_11"

So the question is why I cannot see this index in SSMS? The index is not disabled and not user created since all our indexes start with IX_USERS_XXX

Any suggestions.


  • Is it hypothetical? (What is the value of is_hypothetical in sys.indexes?) Jul 11, 2016 at 19:10
  • No, it is on our production server. I was looking through our statistics and found it but cannot associate it with any indexes on the table
    – Rizwan
    Jul 11, 2016 at 19:12
  • The value of the index is 42 for index_Id
    – Rizwan
    Jul 11, 2016 at 19:13
  • And for the is_hypothetical column? Jul 11, 2016 at 19:13
  • not sure about the value of column... are you asking what columns are included in this index? or is there a query to run to find out
    – Rizwan
    Jul 11, 2016 at 19:16


Browse other questions tagged or ask your own question.