Oracle-L: RE: Outlines Clarification ??

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 27 Nov 2002 07:49:06 -0800
Message-ID: <F001.0050D8FB.20021127074906@fatcity.com>

Having CREATEd the outlines on NON-Partitioned Tables in "RULE" ; On partitioning SOME of the tables & Changing the optimizer_mode="CHOOSE" ,

Will the outlines work for followig SQL Query Cases :-

1) Containing only the partitioned table 
2) SQL Join between multiple partitioned tables 
3) SQL Join containing some PARTITIONED & some NON-Partitioned tables

NOTE - NO change whatsoever done in the Application Software

-----Original Message-----
Sent: Wednesday, November 27, 2002 4:04 PM To: Multiple recipients of list ORACLE-L

The SQL Queries will Remain the SAME , only SOME of the Tables will be paritioned into different tablespaces

We have found our application SQL Queries to work well with RULE , Hence the Creation of the Outlines done in RULE .

But after paritioning since SQL Queries on the PARTITONED Tables will run Only on "COST" we will USE the Outlines so Created Earlier

Unless you mean to keep the Optimizer_mode=RULE even after partitioning to make the optimizer jump back & forth between RULE & COST (depending on whether NON-partitioned Or Partitioned Table is Accessed in the SQL )

Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.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). Received on Wed Nov 27 2002 - 09:49:06 CST