| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: using hints on views
I had to use hints inside views number of times and it worked well but you have to be careful. Hinting just the SQL statement that builds the view may be worse than no hinting at all. When you add hints you have to keep in mind how you will use the view. In result I ended up with few views, selecting the same columns from the same tables but hinted and ordered differently. It may look messy if you just look at the data dictionary but within application you know which button is clicked, what you query on etc... so you know which view you should use.
HTH Witold
On 3 Jan 2002 at 18:55, Maria Aurora VT de la Vega wrote:
> i find the ordered hint extremely helpful...
> so i usually find myself using this hint...
>
> what is your opinion on using hints inside views?
>
> thanks.
>
> --
> Maria Aurora VT de la Vega (OCP)
> Database Specialist
> Philippine Stock Exchange, Inc.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Maria Aurora VT de la Vega
> INET: mtdelavega_at_pse.org.ph
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com -- Author: Witold Iwaniec INET: wiwaniec_at_novalistech.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Fri Jan 04 2002 - 06:27:23 CST
 |
 |