Re: HOW TO SET THE OPTIMIZER_MODE TO COST IN ORACLE 7.2.3 / 7.3.3

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/10/27
Message-ID: <3454B7EB.898B5830@gatwick.geco-prakla.slb.com>#1/1

Pedro,

The optimiser goal you are looking for is either FIRST_ROWS or ALL_ROWS. Either enables the cost with FIRST_ROWS optimised for OLTP (i.e. fast screen response) and ALL_ROWS optimised for DSS (i.e. fast query completion).
Also don't forget, for the optimiser to work you have to have ANALYSED all the tables.

Regards,

Ian Received on Mon Oct 27 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: Jeff Boes: "Trigger using DBMS_PIPE won't parse"
Previous message: Kelly Young: "Re: HOW TO SET THE OPTIMIZER_MODE TO COST IN ORACLE 7.2.3 / 7.3.3"
In reply to: Pedro de Souza Rodrigues Filho: "HOW TO SET THE OPTIMIZER_MODE TO COST IN ORACLE 7.2.3 / 7.3.3"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US