SQLTeam.com | Weblogs | Forums

SQL Table Index Determination

Hello Community,

Very quick question

Can someone let me know how to determine if a table has been indexed?

Thanks

Carlton

Just expand the table node and then you will see list of indexes created on the table under Indexes node.

image

Thank you

ahmed,

Our table looks like the following:

indexing

Does this mean we don't have any indexed columns?

You are at the database node level you need to drill down into the tables node

Yosiaz, thanks for getting in touch, see the following;

Still no indexing, correct?

hi Carltonp ... hope this helps :slight_smile: :slight_smile: .. this is using SSMS TSQL

And now expand each table or better yet run the following in the target database and post results here

SELECT S.NAME SCHEMA_NAME,T.NAME TABLE_NAME,I.NAME INDEX_NAME,C.NAME COLUMN_NAME
  FROM SYS.TABLES T
       INNER JOIN SYS.SCHEMAS S
    ON T.SCHEMA_ID = S.SCHEMA_ID
       INNER JOIN SYS.INDEXES I
    ON I.OBJECT_ID = T.OBJECT_ID
       INNER JOIN SYS.INDEX_COLUMNS IC
    ON IC.OBJECT_ID = T.OBJECT_ID
       INNER JOIN SYS.COLUMNS C
    ON C.OBJECT_ID  = T.OBJECT_ID
   **AND IC.INDEX_ID    = I.INDEX_ID**
   AND IC.COLUMN_ID = C.COLUMN_ID

Ahhhhh.. the following tables are the tables that I'm interested in. So, no indexed columns correct?

indexing2

hi

please see this

image

image

Is this Microsoft sql server??

Yes, MS SQL Server

Hi harishgg1, thanks for getting in touch. I'm not sure where I need to go to find that information?

what version of MS SQL?

Sorry, MS SQL 2014

wonder if someone has hidden the indexes from you? Maybe you do not have permissions to indexes? It is odd that it does not show you the Index node.

image

Are you in
Microsoft SQL server ??

Ahhhh.... do you think that is whats happening? Do I need permission to see the Index node?

Hi Harish,

Yes I'm in MS SQL Server, using SSMS

I can't see the Index node on any of the tables....