How to tell if an Index is being used or not?
Does any know how to tell from the system catalog tables if indexes are being used or not?
This query will return preformance details for a detached Index by
table or just the Index. I mainly look at the "isreads" and the
"bufreads" as this is how often it is used. Anyone else do anything
more?
select *
from sysmaster:sysptprof
where tabname in (select idxname
from product:sysindexes
where tabid in (select tabid
from systables
where tabname = "%TABLE_NAME%"));
select *
from sysmaster:sysptprof
where tabname = "%INDEX_NAME%";
On 8/4/06, DIANNE GARCIA <dianneg@email.utcourts.gov> wrote:
>
> Does any know how to tell from the system catalog tables if indexes are being
> used or not?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
There are thread on c.d.i about tables with lot of sequential scans, and how to identify that tables (Querys, etc.) I think one may say that if a table are hit by lot of sequetial scans then performance goes down and it may be that an index is not used on that table or that it lack of proper indexes. This could be complementary what you are asking for and it could help to identify performance problems. J. DIANNE GARCIA escribió: > Does any know how to tell from the system catalog tables if indexes are being > used or not? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >