Efficient SQL

From: Altitude <rawatd_at_logica.com>
Date: Mon, 14 Jun 1999 10:22:43 +0100
Message-ID: <3764C9E2.96305BBB@logica.com>

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 Mon Jun 14 1999 - 04:22:43 CDT