ED]]
> Sent: Monday, 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 min
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 http://www.e
tion
GlaxoSmithKline
> -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,
>
&g
ist ORACLE-L
> Subject: RE: 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
ssage-
> 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 th
hael A [mailto:maa25681@;GlaxoWellcome.com]
> Sent: Tuesday, October 29, 2002 1:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: What's your opinion: ALL_ROWS vs FIRST_ROWS
>
>
> We're moving from RBO to CBO.
>
> For those of you who use CBO, what mode do you
L PROTECTED]
214.954.1781
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:root@;fatcity.com]On Behalf Of Bishop
> Lewis
> Sent: Thursday, October 31, 2002 3:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: What's your opinion: ALL_ROWS vs FIRST_ROWS
Yes, we have noticed significant response problems after upgrading from
8.0.5 to 8.1.7.4 using FIRST_ROWS. It seems that something new in 8i is
affecting onwards affects the performance.
For example we have a standard DBA script to collect information on extents
against a specified user/table and
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]>
Da
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 recipie
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 PRO
t;Armstead, Michael
>
>
> A" To:
> Multiple recipients of list ORACLE-L
> <[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
"Armstead, Michael
A" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
S
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 gener
15 matches
Mail list logo