Re: Efficient SQL

Thanks for the suggestions and explanations.

Altitude wrote:

> Hi,
>
> We've been looking at improving the efficiency and peformance of some
> Oracle SQL (Both in Pro*C and in triggers). I've found out that for
> SELECT statements, the FROM clause should always have the smallest table
> last (since this is the driving table). Why is this? How does Oracle
> actually parse a SELECT stament and why is this method more efficient?
> My second question is more general ... are there any books which discuss
> the performance and effciency issues with respect to Oracle SQL?
> Nothing to complicated, as I'm only a beginner, but just something which
> will explain to me how to write efficient joins for example.
>
> Any help will be greatly appreciated.
> Thanks in advance.
Received on Tue Jun 15 1999 - 09:08:25 CDT