SQL Table Index Determination

Transact-SQL
1

Hello Community,

Very quick question

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

Thanks

Carlton

2

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

image

3

Thank you

4

ahmed,

Our table looks like the following:

indexing

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

5

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

6

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

indexing2
indexing2.png341×899 23.9 KB

Still no indexing, correct?

7

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

image
image.png1112×387 35.8 KB

8

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
9

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

indexing2

10

hi

please see this

image

image

11

Is this Microsoft sql server??

12

Yes, MS SQL Server

13

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

14

what version of MS SQL?

15

Sorry, MS SQL 2014

16

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

17

Are you in
Microsoft SQL server ??

18

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

19

Hi Harish,

Yes I'm in MS SQL Server, using SSMS

20

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