Oracle-L: RE: Outlines Clarification

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 27 Nov 2002 02:34:18 -0800
Message-ID: <F001.0050D597.20021127023418@fatcity.com>

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

-----Original Message-----
Sent: Wednesday, November 27, 2002 3:36 PM To: VIVEK_SHARMA; LazyDBA.com Discussion

Optimizer must be CBO.
outlines are based on a Query Example: if you create an outline called AXZ for SELECT ename FROM emp; The outline AXZ will be used *if only if*, you query is exactly as "SELECT ename FROM emp;" Note: CBO is sensitiv to cases, blank space etc... so if you type "sElect ENAME from EMP;"...do NOT be supprised to see your plan not showing up..

Regis

-----Original Message-----
Sent: Wednesday, November 27, 2002 9:51 AM To: LazyDBA.com Discussion

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

Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these
terms:http://www.lazydba.com/legal.html

This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible.

This footnote also confirms that this message has been swept for computer viruses.

--

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 - 04:34:18 CST