Re: optimizer rewriting query
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: cjpengel.dbalert@xxxxxxxxx
- Date: Mon, 14 Mar 2005 09:07:33 -0400
In 10g there is a hint that raises an error if the query is not rewriten.
On Sun, 13 Mar 2005 14:10:01 +0100, Carel-Jan Engel
<cjpengel.dbalert@xxxxxxxxx> wrote:
> Excellent point, Mark.
> What does CDTA stand for?
> Acronymfinder suggests Canadian Dance Teachers Association, but I guess
> that's not what you intend here....
>
> Carel-Jan
>
> On Sun, 2005-03-13 at 13:53, Mark W. Farnham wrote:
>
> > We cross an interesting boundary when we switch from humans reading queries
> > to feeding queries to automata. If you're just interested in how the engine
> > works, great. But if Oracle can get a good plan from what you hand to it,
> > then the plan that most naturally represents and documents the intent to a
> > human being is far superior.
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i
8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
//www.freelists.org/webpage/oracle-l
Other related posts:
