Full Table Scans

Hi

We have monitoring software which is telling us that many full table scans are happening in the database.

We want to reduce this if possible.

Is there any SQL to use to tell what is doing the full tablescans? e.g. the database user and the select statement? It is becoming tedious checking the top sql and seeing if it doing full table scans.

Many thanks.

Thiko! Received on Tue Feb 08 2005 - 05:33:58 CST