1. Tables with one index and no clustering
2. Tables with more than one index and no clustering
Table Name: SYSIBM.SYSINDEXES
Col names: NAME (INDEX NAME)
TBNAME (TABLE NAME)
CLUSTERING (Whether or not clustering is on - Y/N)
If I try SELECT * FROM SYSIBM.SYSINDEXES WHERE CLUSTERING = 'N', this gives even the other indexes of a table with more than one index. I just need only with no clustering and should be only index on that table or the rest of indexes are also defined as 'no clustering'.
First things first! Thanks much for the response - you were the only one to respond.
a. The query you had sent looks logical to me and makes sense. However, it did not yield the desired results. I am really not sure why.
b. I am looking for indexes with no clustering and should be only index on that table - the other half which is also needed is - indexes with no clustering and remaining indexes should also be defined with no clustering - on that specific table. In other words, also tables could be with more than one index but all of them defined as 'no clustering'.