How can I find all indexes available on a table in DB2

indexing db2
Rumik picture Rumik · May 20, 2010 · Viewed 88.3k times · Source

How to find all indexes available on table in db2?

Answer

Ingo picture Ingo · May 20, 2010 
db2 "select * from syscat.indexes where tabname   = 'your table name here' \
                                  and   tabschema = 'your schema name here'"

Related questions

AS/400 DB2 Logical File vs Table Index

I'm coming from a MSSQL background, and when I ask people at my company if they've created Indexes on certain columns they'll say yes but point me to these things call Logical Files. In the iSeries Navigator these Logical Files …

Read More
Finding the index of an item in a list

Given a list ["foo", "bar", "baz"] and an item in the list "bar", how do I get its index (1) in Python?

Read More
Getting the last element of a list

In Python, how do you get the last element of a list?

Read More