Re: Sql and pl/sql optimisation

<jean-paul.boyadjian_at_ratp.fr> wrote in message news:MPG.1560af7bead848ff989684_at_news.st-ouen.ratp...
> Hi,
>
> I'm a beginner in sql, and I find great pleasure to work with this
> language. However, it seem that some of my querys take a long time to
> return results...
> So have you tips, or do know web sites talking about sql optimisation?
>
> thanks

Current wisdom seems : it only exists when it is on a website. OK, the Oracle documentation comes with a separate performance tuning manual and is online on http://technet.oracle.com
Your query is way too generic, to provide 'tips' The only useful tip right now is : don't use the rule based optimizer, start using the cost based optimizer rightaway.

Regards,

Sybrand Bakker, Oracle DBA Received on Mon May 07 2001 - 11:13:14 CDT