Re: Query Performance.

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Thu, 25 Jan 2001 19:27:46 GMT
Message-ID: <94pun5$v71$1@nnrp1.deja.com>

So, you are back to EXPLAIN ( and possibly TKPROF ).

Michael.

In article <3a706e2b.1384985641_at_news.alt.net>, SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) wrote:
> On Thu, 25 Jan 2001 14:28:29 GMT, Michael Bialik
> <michael_bialik_at_my-deja.com> wrote:
>
> >Hi.
> >
> > It's quite possible that the response time improved because all data was
> >loaded into memory by the first query. The second query used it without
> >making actual I/O to disks.
> >
> > Michael.
> >
> Thank you, but I checked that out, or so I think. The times are after
> running each query a few times. The times kept gettinmg faster, but
> relative to each other, they were basically the same.
>
> Brian
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 13:27:46 CST