MySQL decide to use no
index in some situations. Mike
- Original Message -
From: Homam S.A. [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: February 22, 2005 8:12 PM
Subject: Avoiding filesort #2
Actually with the query below it does avoid
filesort
no
index in some situations. Mike
- Original Message -
From: Homam S.A. [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: February 22, 2005 8:12 PM
Subject: Avoiding filesort #2
Actually with the query below it does avoid
filesort,
but once I use anything
- Original Message -
From: Homam S.A. [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: February 22, 2005 8:12 PM
Subject: Avoiding filesort #2
Actually with the query below it does
avoid
filesort,
but once I use anything other than the
equal
Actually with the query below it does avoid filesort,
but once I use anything other than the equal operator
(e.g. ColC 5), it reverts back to filesort.
Any thoughts?
--- Homam S.A. [EMAIL PROTECTED] wrote:
I read How My SQL Optimizes Order By
- Original Message -
From: Homam S.A. [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: February 22, 2005 8:12 PM
Subject: Avoiding filesort #2
Actually with the query below it does avoid filesort,
but once I use anything other than the equal operator
(e.g. ColC 5), it reverts back
. This
could confuse the index selection process and have MySQL decide to use no
index in some situations. Mike
- Original Message -
From: Homam S.A. [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: February 22, 2005 8:12 PM
Subject: Avoiding filesort #2
Actually with the query below
: Avoiding filesort #2
Actually with the query below it does avoid
filesort,
but once I use anything other than the equal
operator
(e.g. ColC 5), it reverts back to filesort.
Any thoughts?
--- Homam S.A. [EMAIL PROTECTED] wrote:
I read How My SQL Optimizes Order
. [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: February 22, 2005 8:12 PM
Subject: Avoiding filesort #2
Actually with the query below it does avoid
filesort,
but once I use anything other than the equal
operator
(e.g. ColC 5), it reverts back to filesort.
Any thoughts