Re: Urgent help need for SQL statement tuning

In article <6mbm7d$sp8$1_at_client3.news.psi.net>,   johnj_at_dbbasics.com wrote:

If you are working with ORACLE 7.3 or later aou schould do the following before you execute your SQL.

SQL>set autotrace on

Now your next statements beeing executed are explained automatically.

Now you can refere to ORACLE-DOC on your CD. And watch the part about Tuning SQL. Good luck

Axel

>
> I have the following problem: I have a Customer table and an Order table, both with
> customer_id to join on. I write the following statement.
>
> select a.customer_id
> from customer a, order b
> where a.customer_id=b.customer_id and
> b.rec_date between '01-JUN-98' and '31-JUN-98' and
> a.Country_cd = 1 and
> a.state_cd in ('NC','SC','VA','MD','FL')
>
> when the where clause contains references to Customer and Order it takes for ever
> to run. If the where clause has only Customer or only Order references, it comes
> back immediately. Both tables have about 250,000 records. I am missing something.
> respond to johnj_at_dbbasics.com or news.
>
> John Jones
> DB Basics Inc.
> johnj_at_dbbasics.com
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 19 1998 - 06:51:24 CDT