Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
sanjeev sagar — — source: Informix-list mailing list archive (1991-1998)
I think i did not explain my Q very well. Here it is
again
I want to know the no of btree levels in an index
even before creating table. I know how many no of
rows would be in index but i need to know no of btree
levels in an Index, before create table.
Does it make any sense? In other words any kind of
theoretical equation?
Thanks
Sanjeev
---"Art S. Kagel" <kagel@bloomberg.net> wrote:
>
> 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 index> statistics 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
>
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.