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
I read How My SQL Optimizes Order By
(http://dev.mysql.com/doc/mysql/en/order-by-optimization.html),
and I'm aware of its severe limitation due to the
one-index-per-table rule.
However, even when I follow all the roles, I'm still
getting filesort instead of using the index order.
So I created an
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