I was under the impression that things end up in a tmp table if the query requires
sorting which is when you have either ORDER BY or GROUP BY or DISTINCT
Is that true of false?
regards,
thalis
On Tue, 24 Apr 2001, Seung-woo Nam wrote:
> I don't think you can avoid having those temporary table
I don't think you can avoid having those temporary tables in executing
any kind of SELECT queries since the retrieved information should be
stored somewhere (whether you have ORDER BY or not). I would suggest
that if you have a large database, you should considering putting the
temporary space on
ut the ORDER BY clause.
Scott
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Gerald Clark
Sent: Tuesday, April 24, 2001 10:33 PM
To: Scott
Cc: [EMAIL PROTECTED]
Subject: Re: Query Copying to Temp Table
Scott wrote:
>
> I am running into a
Scott wrote:
>
> I am running into a problem here with a general query that is essential
> to the vitality of a website that I run. The problem is that every time
> this query is executed, it is being copied to a temporary table on the
> hard disk, causing an extreme slowdown. In some instances
I am running into a problem here with a general query that is essential
to the vitality of a website that I run. The problem is that every time
this query is executed, it is being copied to a temporary table on the
hard disk, causing an extreme slowdown. In some instances it takes up
to 5 minute