Re: Improvement of the select sentence

From: Michael Bialik <bialik_at_isdn.net.il>
Date: 1 Oct 2001 14:30:05 -0700
Message-ID: <969f8022.0110011330.a284065@posting.google.com>

Hi.

Verify that you have following indexes:
1. Index on Otherfield of Table1 - In order do make it driving table. 2. Index on fieldId of Table2 - To enable nested-loop join ( If you are using rule based optimizer or cost based optimizer and selecting small percentage of Table1 rows ( based on Otherfield value )). 3. Index on fieldId2 of Table3 ( see par.2 )

HTH. Michael. Received on Mon Oct 01 2001 - 16:30:05 CDT