SURVEY RBO VS CBO

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 29 Oct 2001 16:03:14 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA72714ED@lnewton.leeds.lfs.co.uk>

2 instances at 7.3.4 = RBO
All the rest (approx 30+) at 8.0, 8.1 = CBO

Servers = HP-UX 10:20 and 11:00 (23 and 64 bit), Digital Unix 4.0d, Open VMS (yeuch !), NT4 (yeuch!)

Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

-----Original Message-----

From: FrantzG [mailto:fguionne_at_hotmail.com] Posted At: Friday, October 26, 2001 9:23 AM Posted To: server
Conversation: SURVEY RBO VS CBO
Subject: SURVEY RBO VS CBO

Hi All,

A lot has been said about Ruled Based Optimizer VS Cost Based Optimizer but
I would like to launch this quick survey : Which one are you currently using in Production ? and what version of Oracle
are you currently on ?

Thank You
Frantz Guionnet Received on Mon Oct 29 2001 - 10:03:14 CST