-
Hi,
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
thanx
-
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.
Good luck.
-
Use the following :
Use the following link to establish which code is problematic and what to do about it :
http://www.dbspecialists.com/4dbas/p...e_explain.html
Cheers
Suresh
-
Hi
Set autotrace on in Sqlplus and then
Fire your select on sqlplus and you have the Stats in front of u .
Hope that helps .........
Cheers
Afshin
-
Thanx a lot!!!
it was there in toad..a bit of search......
thanx a lot again