My opinion:

- Select return correct data
- Select has performance far from optimal

KAzi

Fahd Mirza wrote:

>Hi,
> What would be the definition of a poorly written SQL?
>-sql, with wrong join order
>-sql, which uses dual
>- sql, having no bind variables etc etc.
>regards,
>Fahd
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>


Oracle LazyDBA home page