Hi,
I ran the utlbstat and utlestat scripts on my database and got the following output for table scans. This shows that I have a lot of Full Table Scans according to the formula

Non Index Lookup ration = Table Scans (Long Tables) / Table Scans (Long Tables) + Table Scans (Short Tables) = 16%.

What is the best approach I should take to tackle this problem.

Thanks
Anurag


Statistic Total
---------------------------------------------------------------- ------------
Per Transaction Per Logon Per Second
--------------- ------------ ------------
table scans (long tables) 3195
19.97 59.17 .16

table scans (short tables) 15666
97.91 290.11 .79