Re: optimizer_max_permutations

Yes, it is required in one of our COTS applications.

Inserts into complex views with instead-f triggers.

The views are quite complex, ridiculously so, one might say.

Before setting optimizer_max_permutations=1000, it took a very long time to parse those views.

Jared

On Tue, 2003-08-26 at 05:44, Boivin, Patrice J wrote:
> Has anyone worked with this one?
>
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch11
> 23.htm#81357
> <http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch1
> 123.htm#81357>
>
> Patrice.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).