Index usage scripts
One of customer want to collect the index page space usage ,Do anyone could provide the scripts?
CHUAN LU wrote:
Space use or IO stats?
Space use, this will work for fully detached indexes (all indexes
created in versinos later than 7.31/9.30) for indexes in a single logged
database:
database 'mydatabase';
select idxname, sum(npused)
from sysindexes si, sysmaster:systabnames st, sysmaster:sysptnhdr sh
where st.dbsname = 'mydatabase'
and si.idxname = st.tabname
and st.partnum = sh.lockid
;
Art S. Kagel
Oninit
> One of customer want to collect the index page space usage ,Do anyone could
> provide the scripts?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference
> The Power Conference for Informix Professionals
> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
> http://www.iiug.org/conf
> Registration Now Open!!
>
>
================================================================================
===========
> Please access the attached hyperlink for an important electronic
communications disclaimer:
>
> http://www.oninit.com/home/disclaimer.php
>
>
================================================================================
===========
>
>
>
================================================================================
===========
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.oninit.com/home/disclaimer.php
================================================================================
===========