| explain plan [message #326131] |
Tue, 10 June 2008 05:05  |
bm50793
Messages: 7
Registered: June 2008
|
Junior Member |
|
|
hi All,
i want to know details about the below given execution plan
can you please tell me the follwing
1)what actually column one repetesents i.e., first line number and similarly other columns also
2)is there any relation between column one and two(line number 1(red colored ) and 2(blue colored)) if yes how they are related
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=147166 Card=18510611
9 Bytes=25544644422)
1 0 HASH JOIN (Cost=147166 Card=185106119 Bytes=25544644422)
2 1 HASH JOIN (Cost=415 Card=241855 Bytes=19590255)
3 2 TABLE ACCESS (FULL) OF 'COUNTRY' (Cost=1 Card=182 Byte
s=4550)
4 2 PARTITION RANGE (ALL)
5 4 TABLE ACCESS (FULL) OF 'SUBSCRIBER' (Cost=413 Card=2
41855 Bytes=13543880)
6 1 VIEW (Cost=121686 Card=7653599 Bytes=436255143)
7 6 SORT (GROUP BY) (Cost=121686 Card=7653599 Bytes=765359
900)
8 7 PARTITION RANGE (ALL)
9 8 TABLE ACCESS (FULL) OF 'COMMPOS' (Cost=5757 Card=7
653599 Bytes=765359900)
thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
