RE: Oracle position on hints

[Jamadagni, Rajendra]

in 9202, oracle uses hard coded hints for recursive SQL ... and they say that analyzing SYS schema is okay ...

 

Ha !!

Raj

-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle position on hints

The first day hints are gone, I will change my career!

 

I do not think it will go away, since Oracle itself uses them to control the way PQ slaves and other background processes work.

 

Also stored outlines is part of it.

 

Regards,

 

Waleed 

-----Original Message-----
From: Stephane Paquette [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle position on hints

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

[EMAIL PROTECTED]

 

********************************************************************This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*********************************************************************2