Re: SQL Optimization

From: Dagmar A. Bogan <dagmar_at_indian.mitre.org>
Date: 10 Nov 1993 13:04:04 GMT
Message-ID: <2bqos4$3h7_at_linus.mitre.org>

Unfortunately, everyone seems to have an opinion on tuning, but here's my ideas:

1. Join the tables rather than use the WHERE...IN clause, if possible
2. Run EXPLAIN PLAN to get an idea of what is going on, and if any indices are being used (but if you are retreiving more than 15% of the records, your probably better off doing a full table scan)

   ---

The opinions expressed herein do not necessarily reflect those of The MITRE Corporation.

---

---

Dagmar Anne Bogan                     *
Software Engineering Center           *
The MITRE Corporation                 * phone: 703.883.6093
M/S Z676                              * fax:   703.883.6991
7525 Colshire Drive                   * email: dagmar_at_indian.mitre.org
McLean, Virginia  22102-3481          *


******************************************************************************

Received on Wed Nov 10 1993 - 14:04:04 CET