Post reply

same table , why it shows different numbers of indexes?

  • December 9, 2020 at 1:46 am

    #3818443

    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.

  • December 9, 2020 at 1:48 am

    #3818445

    sorry, my sql server is 2008 R2

  • December 9, 2020 at 1:58 am

    #3818450

    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, 11 months ago by  Lynn Pettis.

  • December 9, 2020 at 4:26 am

    #3818481

    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