Re: SQL performance question

From: Emre Akbag <akbag_at_scr.siemens.com>
Date: Mon, 25 Sep 2000 18:17:44 -0400
Message-ID: <A7Qz5.4704$l35.106398@iad-read.news.verio.net>

autotrace command of SQL would also help you!

<terry_stjean_at_my-deja.com> wrote in message news:8qo711$5tv$1_at_nnrp1.deja.com...
> I have an SQL select statement which I would like to see if I can get
> to run faster.
> I have a transaction table with 15 million records joined to 3 master
> tables. One has 1500 records, one has 11000 records and the other about
> 15 records.
> Besides joining these tables on the where clause, I am also selecting
> certain records.
> Any suggestions about optimizing. Does the order on the from or where
> clause matter.
>
> Terry
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 25 2000 - 17:17:44 CDT