Table depths
IIUG gurus,
I am doing some investigations of the depth of various B-tree instances in
some Informix db's. I am using oncheck -pT to do this but it produces a lot of
superfluous information. Any suggestions for alternatives?
I am running IDS 7.3 on Solaris.
Paul Storm
↪ replying to Paul Storm
Paul Storm wrote:
>
> IIUG gurus,
>
> I am doing some investigations of the depth of various B-tree instances in
> some Informix db's. I am using oncheck -pT to do this but it produces a lot of
> superfluous information. Any suggestions for alternatives?
>
> I am running IDS 7.3 on Solaris.
SELECT tabname, idxname, nlevels
FROM sysindexes i, systables t
WHERE i.tabid = t.tabid
ORDER BY 1, 2;
Art S. Kagel