Re: SQL performance question

From: Emre Akbag <akbag_at_scr.siemens.com>
Date: Tue, 26 Sep 2000 09:50:32 -0400
Message-ID: <0O1A5.4904$l35.110362@iad-read.news.verio.net>

what if he is the DBA?
;-)

"Steve Long" <steven.long_at_erols.com> wrote in message news:8qp533$pmj$1_at_bob.news.rcn.net...
> you could ask your dba. ;)
>
>
> <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 Tue Sep 26 2000 - 08:50:32 CDT