Re: B-Tree Levels of IDS

Posted in 1998

Art S. Kagel — Tue, 27 Oct 1998 11:30:52 -0500 — source: Informix-list mailing list archive (1991-1998)

Lucie Janstova wrote: > Try: > select * from sysindexes > where idxname = "my_index"; This works if the statistics are updated by UPDATE STATISTICS LOW ... or UPDATE STATISTICS HIGH... on the table (MEDIUM does not update indexstatistics only distributions). > Lucy (lucie.janstova@post.cz) > sanjeev sagar wrote in message <712vps$33r$1@news.xmission.com>... > >I am using IDS 7.30 on Solaris 2.5.1 I am having one Q > > > >How can i find out total no of btree index levels, if > >I know the total no of rows in the index? Art S. Kagel