| explain plan [message #456554] |
Tue, 18 May 2010 08:16  |
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  |
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 |
cookiemonster
Messages: 13922
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
