Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle position on hints

RE: Oracle position on hints

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Sat, 08 Mar 2003 11:13:37 -0800
Message-ID: <F001.0056401A.20030308111337@fatcity.com>


Stephane

   I don't see how Oracle could ever have an official position on hints. If they say hints are going away, many developers panic. If they say hints are great, then Oracle competitors will claim Oracle has a bad optimizer.

   A key political issue in some shops is "Using hints makes our code Oracle-specific". My reply is that hints are only comments that another database will ignore.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

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

Sent: Friday, March 07, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L

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 services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).

--

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 services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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 Sat Mar 08 2003 - 13:13:37 CST

Original text of this message

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