OraFAQ Forum: Performance Tuning » query_rewrite

Home » RDBMS Server » Performance Tuning » query_rewrite_enabled (10G)

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

query_rewrite_enabled [message #411387]

Fri, 03 July 2009 05:57

farenheiit
Messages: 31
Registered: June 2009
Location: Paris

Member

Hi,

I'd want to know if the fact that the query_rewrite_enabled parameter is set to TRUE can explain performance query issues after a migration from 9i to 10G.

I remember reading in Gavin POWELL's book that with this parameter set to TRUE execution plans may be altered.

is this parameter realyy usefull if we don't use Materialized views ?

thanks for helping

Report message to a moderator

Re: query_rewrite_enabled [message #411405 is a reply to message #411387]

Fri, 03 July 2009 07:11

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I believe that you used to need Query_Rewrite_Enabled for function based indexes, but I'm petty sure you don't need it for that in 10g.

As far as I know, having it set to true will only alter an execution plan if there is a materialized view that can be used in place of pat of the query.

Report message to a moderator

Re: query_rewrite_enabled [message #411416 is a reply to message #411387]

Fri, 03 July 2009 07:52

farenheiit
Messages: 31
Registered: June 2009
Location: Paris

Member

So what can explain that a query which used running very fastly in 9i, is now running very slowly in 10G? the volumetric is the same...

i've set the OPTIMIZER_FEATURES_ENABLE parameter to 9.2.0 and the SQL plan is still the same

Report message to a moderator

Re: query_rewrite_enabled [message #411439 is a reply to message #411387]

Fri, 03 July 2009 10:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So what can explain that a query which used running very fastly in 9i, is now running very slowly in 10G? the volumetric is the same...
Post EXPLAIN PLAN from both servers.

Are statistics current on V10?

[Updated on: Fri, 03 July 2009 10:46]

Report message to a moderator

Re: query_rewrite_enabled [message #411449 is a reply to message #411439]

Fri, 03 July 2009 17:44

farenheiit
Messages: 31
Registered: June 2009
Location: Paris

Member

of course, I've ever checked this point

Report message to a moderator

Previous Topic:	Statistics on Empty Partition
Next Topic:	Performance question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 16:49:42 CST 2024