Re: Avoiding filesort #2

2005-02-23 Thread Homam S.A.
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

Re: Avoiding filesort #2

2005-02-23 Thread mos
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

Re: Avoiding filesort #2

2005-02-23 Thread Homam S.A.
- 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

Avoiding filesort #2

2005-02-22 Thread Homam S.A.
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

Re: Avoiding filesort #2

2005-02-22 Thread Mike OK
- 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

Re: Avoiding filesort #2

2005-02-22 Thread Mike OK
. 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

Re: Avoiding filesort #2

2005-02-22 Thread Homam S.A.
: 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

Re: Avoiding filesort #2

2005-02-22 Thread mos
. [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