is there a possible way to find if select query fired is doing a table scan or an index scan?
I have a table with xactlt 3 lac and 14 rows.....
and a select query takes ages to to retrive result....
though 5 cols have been indexed...
any suggestions welcome
Just a reminder
and is there a way to see the plan..as toike which objects oracle seeks during the search
something like a table plan?
Look for some documentation on the EXPLAIN PLAN utility. A full explanation is too long for a post.
This utility will help identify full table scans.
One other point: it is possible to overindex.
Use the following :
Use the following link to establish which code is problematic and what to do about it :
Set autotrace on in Sqlplus and then
Fire your select on sqlplus and you have the Stats in front of u .
Hope that helps .........
Thanx a lot!!!
it was there in toad..a bit of search......
thanx a lot again