Re: Where is that index?
On Sun, 14 Mar 2004 23:30:38 -0500, Peter Harris wrote:
If the table is fragmented or the index is either detached or fragmented:
select dbspace from sysfragments where index_name = 'myindexname';
If the index is attached to a non-fragmented table:
select dbinfo('dbspace', partnum)
from systables
where tabname = 'mytablename';
It is left for the reader as an exercise ;-) if one knows the indexname but
not what non-fragmented table it belongs to.
Art S. Kagel
> Dear all,
>
> I am running Informix 7.31 UDF4 on solaris 8. Given an index name, is there
> a way of finding out which dbspace it is physically residing in?
>
> //Pete