Index Levels
Query to find index levels.
set isolation to dirty read;select tabname[1,18], idxname[1,18], levels
from sysindexes, systables
where sysindexes.tabid = systables.tabid
and levels > 2
order by 1 asc,3 desc
Query to find index levels.
set isolation to dirty read;select tabname[1,18], idxname[1,18], levels
from sysindexes, systables
where sysindexes.tabid = systables.tabid
and levels > 2
order by 1 asc,3 desc