| jothi |
Posted: Nov 26, 2007 01:33:07 PM |
Total Post: 24
Joined: Aug, 2007
|
hi,
can anyone tell me about full table scan?what does it mean
thanx, |
|
|
 Mohammed Taj |
| Posted: Nov 26, 2007 11:25:15 PM |  |
|
Total Post: 694
Joined: Jul, 2007
|
http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/optimops.htm#44852
|
|
|
|
|
| praveen |
| Posted: Nov 27, 2007 12:09:33 AM | |
|
Total Post: 3
Joined: Nov, 2007
|
Full table scan means, while searching data for Ur query it will
look for whole data present in table.
|
|
|
|
|
| jothi |
| Posted: Nov 27, 2007 09:30:11 AM | |
|
Total Post: 24
Joined: Aug, 2007
|
Thank you Mr.Taj & Mr.praveen
|
|
|
|
|
| Vinod |
| Posted: Dec 10, 2007 06:40:04 PM | |
|
Total Post: 54
Joined: Oct, 2007
|
Hi Sudhar,
You can use the below mentioned query to list out the objects
which are experiencing a full tablescan
select a.object#, a.operation, a.options,b.object_name,b.owner
from v$sql_plan a,dba_objects b
where operation='TABLE ACCESS' and options='FULL'
and a.object# = b.object_id
and b.owner NOT IN ('SYS','SYSTEM','XDB')
/
Thanks & Regards,
Vinod
|
|
|
|
|
| positive |
| Posted: Jun 27, 2008 06:22:18 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
It is usual practice to use index as the first point of reference while querying the table.At times the optimizer determines the optimal execution plan that skips index and does the scanning of table to locate the data.
It is advisable to keep full table scans at a minimum as it will have an impact on performance.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
