Full Table Scans

Database
Enthusiast

Full Table Scans

Hi All,

I would like to know where the information is about queries performing Full Table Scans or using Index Scans. If you could share the query that would be really great. This would really help me narrow down things and could help me identify clients queries performing badly and not using Index.

Thanks in advance

1 REPLY
Junior Contributor

Re: Full Table Scans

Hi Usmans,

you can probably get that info from DBQL, a high "Unneccessary IO" ratio (=Higa Larry Ratio) for retrieve steps indicates lots of IO, but hardly CPU.

If DBQL is enabled on objects you might check if there's an ObjectType = 'IDX' for a query.

Dieter