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
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.