Home › Blogs › Christoph C. Cemper's blog
Oracle

What is the rule based optimizer ? :-)

<< Google rejects Microsoft offers | Interesting stuff from last week >>
Sun, 11/02/2003 - 23:28 — Christoph C. Cemper

An obvious lucky visitor asked Google what is the rule based optimizer ? and came to my 10G post … well – yes – i guess outside the Oracle world people don't really are able to/have to tweak the SQL engine as we did in Oracle…

Average rating
 
 
 
 
 
(0 votes)

Comments

Mon, 12/01/2003 - 13:19 — eyad (not verified)

What is the rule based optimizer ? :-)

i want to learn more about rbo and cbo
how did work
and how to force oracle to choose the way to execute a query ?

Mon, 01/26/2004 - 13:15 — Naresh Singh (not verified)

What is the rule based optimizer ? :-)

Please send me the details of RBO and CBO

how to optimize the queries for beteer performance.

Similar entries

  • Cost Control: Inside the Oracle Optimizer

    Cost Control: Inside the Oracle Optimizer For developers migrating applications to an Oracle Cost-Based Optimizer environment (or creating new ones), this technical article contains invaluable information about CBO configuration and statistics management. [via Oracle Technology Network News] — Composed with…

  • Oracle 10G dropping rule-based optimizer and 8i + 9i R1 - supporting Regular Expressions in SQL and PHP

    Oracle Database 10G dropping rule-based optimizer, introducting regular expressions and PHP

  • Generate Execution Plans Directly from the Library Cache

    Oracle DBA Pipeline has a nice tip on how to generate execution plans directly from the Library Cache, a feature introduced in Oracle9i that brought with it the capability to view execution plan information for all parsed cursors stored in…

  • Oracle 10G - new tech articles

    Oracle has some interesting 10G articles up on OTN: Auto-Tuning Oracle Database 10g Oracle Database 10g supports the automation of more routine DBA tasks than ever before. The techniques described here can help you begin to implement Oracle SGA self-tuning…

  • Google Glossary

    Use Google's new operator "define" to access the glossary features from the previous Google Labs demo… example1: define: google example2: define: googol rocking example3: define: euphemism demonstrates that they list a pseudo pronunciation for some words – it is YOO-fuh-mizm…