same table , why it shows different numbers of indexes?

  • the same table, I use sp_helpindex tablename, it displays 8 indexes, but I check the index under table' s Indexes node, it display 7 indexes, in the picture, the first index of the right part is not included in the left part,  and there is a statistics information for the first index of the right part under the table's statistics node . could you please tell me the reason?  thanks!

    Attachments:
    You must be logged in to view attached files.
  • sorry, my sql server is 2008 R2

  • You have a hypothetical index in the list on the right.  It isn't a real index  Google search the following: MS SQL Server hypothetical indexes

     

     

    • This reply was modified 3 years, 3 months ago by  Lynn Pettis.
  • Lynn Pettis wrote:

    You have a hypothetical index in the list on the right.  It isn't a real index  Google search the following: MS SQL Server hypothetical indexes

    ok,I'll google what the MS SQL Server hypothetical indexes is.  I don't know when system will create this kind of index. thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply