|
View previous topic :: View next topic
|
| Author |
Message |
monasu1998
Active User
Joined: 23 Dec 2005
Posts: 176
Location: India
|
|
|
|
Hi All:
I have a typical requirement.
1) I want to find out the number of INDEXes are there in a table.
Same way I want
2) The indexes are indexed on which column?
Please help me out.
Thanks in Advance, |
|
| Back to top |
|
 |
gskulkarni
New User
Joined: 01 Mar 2006
Posts: 70
|
|
|
|
You can run spufi query on SYSIBM.SYSINDEXES table to retrieve number of indexes on your tables.
SYSIBM.SYSKEYCOLUSE can give you index columns. |
|
| Back to top |
|
|
gskulkarni
New User
Joined: 01 Mar 2006
Posts: 70
|
|
|
|
| If you run spufi on SYSIBM.SYSKEYS to retrieve IXNAME = NAME of SYSIBM.SYSINDEXES you will get the related index columns. |
|
| Back to top |
|
|
|
|
