How to find how many columns are indexed in a table

babuprasad_g · New User Joined: 26 May 2005 Posts: 45 Location: gurgaon

In a table there is lot of cloumns.how will we find how many columns are indexed.
what is the way to find out indexing columns.

shobam · New User Joined: 18 Jul 2005 Posts: 34 Location: CN

To get the list of all indexes in a table , Try this SQL statement

SELECT *
FROM SYSIBM.SYSINDEXES
WHERE TBNAME = 'TableName'
AND TBCREATOR = 'CreatorName';

Please correct me If I am wrong.

ragshere · New User Joined: 20 Dec 2004 Posts: 70

Hi,
Querying SYSINDEXES Table will provide only the index name and its property(unique,duplicate).
You have to query SYSKEYS table with the index name to know the columns included in that index.