Re: SQL performance question

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Tue, 26 Sep 2000 14:28:20 -0700
Message-ID: <8qr4di$jm4$1@spiney.sierra.com>

then say "Please".

"Steve Long" <steven.long_at_erols.com> wrote in message news:8qr3k8$f9m$1_at_bob.news.rcn.net...
> and what if "he" is a "she" ?
>
> "Emre Akbag" <akbag_at_scr.siemens.com> wrote in message
> news:0O1A5.4904$l35.110362_at_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 - 16:28:20 CDT