On Sep 4, 3:21 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote:
> On Sep 4, 3:15 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote:
>
>
>
> > On Sep 4, 2:15 pm, mohitanch...@gmail.com wrote:> I tried running following query to get the total size of index for a
> > > given table but I don't get any results. My indexes are in separate
> > > dbspace as of row data:
>
> > <SNIP>
>
> > Try this one Mohitan:
>
> > select dbinfo( 'dbspace', sph.partnum ) dbspace, st2.dbsname
> > database,
> > st2.tabname partition, nptotal, npused,
> > npdata, (npused - npdata) npindex
> > from systabnames st1, systabnames st2, sysptnhdr sph
> > where st1.partnum = sp.lockid and st2.partnum = sph.partnum
> > and st1.dbsname = 'mydatabase' AND st1.tabname = 'mytable'
> > order by 2, 3, 1;
>
> > To filter for a particular index add a filter on: " and st2.tabname =
> > 'myindexname' "
>
> > Art S. Kagel
>
> the " sp.lockid " should be " sp2.lockid "
>
> Art S. Kagel

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

Trying again:

the " sp.lockid " should be " sph.lockid "

Art S. Kagel