Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Oracle position on hints
Though I have yet to try out stored outlines, I believe that they
have legitimite uses. Making your dev system work like
production comes to mind.
As others have stated about hints, they have legitimite uses as well. They can be very handy to have when you need to make a poorly written application behave a little better.
The use of ALL_ROWS and FIRST_ROWS are very useful hints to have around, and they don't tell the CBO how to do its job, they just tell it what your preference is for returning data.
Jared
dgoulet_at_vicr.com
Sent by: root_at_fatcity.com
03/07/2003 11:29 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: Re:RE: Oracle position on hints
Stephane,
I'm going to agree with many on the list in that I don't believe
Oracle will
drop the concept. But on the other hand I don't like them either, not do
I like
the idea of stored outlines either. The reason is that with both your
trying to
ham string the optimizer into doing things your way, which may be just
fine
today but when you add a gazillion rows of data things change & that
highly
selective index you were sure you wanted to use is now less than useless.
I
don't think hints were introduced because Oracle's optimizer is immature,
it
actually appears to be more matured than most other vendors, but that some
duhvelepors want things their way.
Dick Goulet
____________________Reply Separator____________________ Author: "Stephane Paquette" <stephane.paquette_at_standardlife.ca> Date: 3/7/2003 10:19 AM
Hi,
I have to write a SQL and PL/SQL guide for our developpers. Some are good but most of them can use help.
I'm not a big fan of hints except for insert append, I used them only if I really need to.
In last october I went to a 3 days DB2 UDB course, unless I miss something
there are no hint with DB2 UDB.
So I was thinking that when the Oracle optimiser would be more mature
maybe
hints would go away.
I just want to know what is Oracle direction with hints.
TIA Stephane
-----Original Message-----
Robert - IL
Sent: Friday, March 07, 2003 12:01 PM
To: Multiple recipients of list ORACLE-L
This is facinating, where does this come from? This is the second time in
a
week that I've heard this statement being made by someone. Hints will
never
go away IMHO, and Oracle continues to add more and more of them. I was
told
by someone at a client site that they were told by an Oracle instructor
that
they should not use hints in 9i....
RF
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 3/7/2003 10:04 AM
Hi,
Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ?
TIA Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tél. (514) 925-7187
stephane.paquette_at_standardlife.ca
<mailto:stephane.paquette_at_standardlife.ca>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
INET: FREEMANR_at_tusc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Paquette
INET: stephane.paquette_at_standardlife.ca
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: dgoulet_at_vicr.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Mar 10 2003 - 11:44:13 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |