explain plan [message #456554] |
Tue, 18 May 2010 08:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
orafacjublu
Messages: 95 Registered: May 2006 Location: KOLKATA
|
Member |
|
|
Can we have same execution plan for a create table statement where the name of the table changes every time as follows:
create table test
as
select * from t1
Here table name changes from test to another table name next time
|
|
|
|
|
|
Re: explain plan [message #456562 is a reply to message #456559] |
Tue, 18 May 2010 08:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
orafacjublu
Messages: 95 Registered: May 2006 Location: KOLKATA
|
Member |
|
|
say,
explain plan for
create table test1
as
select * from abc
after creating table test1 if I execute the following
explain plan for
create table test5
as
select * from test1
The explain plan doesn't use the earlier explain plan but I need it.Can we do?
|
|
|
|
Re: explain plan [message #456567 is a reply to message #456564] |
Tue, 18 May 2010 08:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Explain plans and execution plans are specific to queries.
You are running two different queries (it might be getting the same data but it is getting it from a different place).
Why would you expect them to be the same?
What are you trying to achieve?
|
|
|