PROTECTED]
To: Rolando Edwards [EMAIL PROTECTED]
Cc: MySQL General mysql@lists.mysql.com
Sent: Monday, November 6, 2006 9:58:23 AM GMT-0500 US/Eastern
Subject: RE: Copy to tmp table optimize
id, select_type, table, type, possible_keys, key, key_len, ref, rows,
Extra
1, 'SIMPLE', 'logs_2006_11', 'ALL
You need to look at the GROUP BY clause
If all the columns from a GROUP BY clause
are not indexed or if the columns in the
GROUP BY clause are from different tables,
MySQL will use the temp table.
Please send your query to the MySQL List
and the structure of all tables in the query
-
: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:02 AM
To: Francis
Cc: MySQL General
Subject: Re: Copy to tmp table optimize
You need to look at the GROUP BY clause
If all the columns from a GROUP BY clause
are not indexed or if the columns in the
GROUP BY clause
: Francis [EMAIL PROTECTED]
To: Rolando Edwards [EMAIL PROTECTED]
Cc: MySQL General mysql@lists.mysql.com
Sent: Monday, November 6, 2006 9:31:32 AM GMT-0500 US/Eastern
Subject: RE: Copy to tmp table optimize
Hi
This is my SQL command:
Select cs_documents.str_url FROM logs_2006_11
LEFT Join
, 'Using where'
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:54 AM
To: Francis
Cc: MySQL General
Subject: Re: Copy to tmp table optimize
As for this part of your query
(
cs_documents.str_url LIKE '%.asp
.int_url_strem', 1, 'Using where'
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:54 AM
To: Francis
Cc: MySQL General
Subject: Re: Copy to tmp table optimize
As for this part of your query
(
cs_documents.str_url LIKE '%.asp