, November 04, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS
Hi Mike,
Your article was very good in describing RBO vs. CBO. I hope
you don't mind
me using it to help better describe why we're switching from
RBO
: What's your opinion: ALL_ROWS vs. FIRST_ROWS
Note: When leaving your web page I was notified that my IP address was
captured. I didn't like that.
Michael Armstead
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City
-Original Message-
From: John Kanagaraj [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 31, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: What's your opinion: ALL_ROWS vs FIRST_ROWS
Mike,
Check this out and let me know if this is helpful. Larry has
Hi Mike,
Your article was very good in describing RBO vs. CBO. I hope
you don't mind
me using it to help better describe why we're switching from
RBO to CBO to
my team.
I forgot to mention this before, but you should also look at Tim Gorman's
excellent paper on the CBO at
:
lcome.com
Subject: What's your opinion: ALL_ROWS vs
FIRST_ROWS
Sent
We have an OLTP system that I thought will benefit from first rows.
The sad fact is that when I set optimization to first rows the response
sucks.
Do some testing, as you can change this anytime.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
I guess that's why when I take a look at the initialization files of
databases in large shops where it's expected the DBAs know what they're
doing, by and large the databases are running in CHOOSE (all rows if there
are sufficient statistics) mode.
- Original Message -
To: Multiple
Besides, I have seen the Oracle Consulting prefers to set optimizer to
'CHOOSE' wherever they did their project for customized
application/databases(not Oracle Financials 10.7)
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
We're moving from RBO to CBO.
For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS?
And why?
My thinking is if it's a database where most of the querying is done on
small sets of records, then we may want to use FIRST_ROWS. On the other
hand, if our database is used to
:
lcome.com Subject: What's your opinion:
ALL_ROWS vs FIRST_ROWS
Sent by:
[EMAIL PROTECTED
Armstead, Michael A wrote:
We're moving from RBO to CBO.
For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS?
And why?
My thinking is if it's a database where most of the querying is done on
small sets of records, then we may want to use FIRST_ROWS. On the other
11 matches
Mail list logo