Home » RDBMS Server » Performance Tuning » explain plan
explain plan [message #326131] Tue, 10 June 2008 05:05 Go to next message
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
Re: explain plan [message #326152 is a reply to message #326131] Tue, 10 June 2008 06:20 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Previous Topic: About tkprof
Next Topic: diskreads/executions
Goto Forum:
  


Current Time: Sat Dec 10 18:55:12 CST 2016

Total time taken to generate the page: 0.08643 seconds