Home » RDBMS Server » Performance Tuning » Does view change table_plan for select stmts. on base table
Does view change table_plan for select stmts. on base table [message #215682] Tue, 23 January 2007 08:45 Go to next message
liegler.joerg
Messages: 1
Registered: January 2007
Junior Member
I have a base table "person". I have a select statement that executes in 7 steps with 700 cost points.

Later i built a view and executed the same select statement on the base table. Now the table_plan says it takes 9 steps with 10010 cost points.

Question is: Does a view alter the execution plan for all select statements on the base table? Why?
Re: Does view change table_plan for select stmts. on base table [message #215695 is a reply to message #215682] Tue, 23 January 2007 09:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Difference should not be significant.
you need to provide more information. OS, Oracle version, available statistcs, load and concerned sql along with plan/trace.
Oracle dictionary itself is based on hundred of views and does a pretty decent job. Yours might be a different case.
Regards
Re: Does view change table_plan for select stmts. on base table [message #215697 is a reply to message #215695] Tue, 23 January 2007 09:46 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1353453813863
Previous Topic: Tuning in 10g
Next Topic: Partitioning with ONline Redefinition
Goto Forum:
  


Current Time: Sat Dec 10 14:45:51 CST 2016

Total time taken to generate the page: 0.10174 seconds