Re: sysindexes: leaves and levels empty?
On 8 Sep 1997 14:52:29 GMT, sn192he@d250-hrz.uni-duisburg.de (Heckers)
wrote:
>Hello!
>
>I'm playing around with the sysindexes table to write a 'recreate index' utility.
>I tried
>---
>#!/usr/bin/ksh
>dbaccess << EOF
>database sysmaster
>select idxname, tabid, leaves, levels from sysindexes;>EOF
>---
>but the columns for leaves and levels are always empty.
>
>I would like to get this information to calculate a
>value for starting or skipping a 'recreate index'.
>
>The printed documentation says nothing about these columns.
>(Informix Guide to SQL, V 7.2 : System Catalog)
>
>Thankx,
> Erik
>
These fields are only updated when you run update statistics on your
tables...
Richard