OraFAQ Forum: Performance Tuning » Does view change table

Home » RDBMS Server » Performance Tuning » Does view change table_plan for select stmts. on base table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Does view change table_plan for select stmts. on base table [message #215682]

Tue, 23 January 2007 08:45

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?

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1353453813863

Report message to a moderator

Previous Topic:	Tuning in 10g
Next Topic:	Partitioning with ONline Redefinition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:16:00 CST 2024