IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Re: I approached that from another direction.
Post #284,834
by dws
5/17/07 1:41:19 AM
Reply
New Re: I approached that from another direction.
EXPLAIN is your friend in weird cases like this. If you find that MySQL, for reasons obscure, has decided to do a full table scan, you can use a FORCE INDEX hint to set things right (for MySQL 5.0+, at least).

[link|http://dev.mysql.com/doc/refman/5.0/en/index-hints.html|http://dev.mysql.com.../index-hints.html] for details.
Post #284,847
by static
Picture of static
5/17/07 8:40:14 AM
Reply
New FORCE INDEX is new to me.
I had been using EXPLAIN. And USE INDEX. With it without USE INDEX, a month or half-a-month, it still uses the correct index. I'll try FORCE INDEX, though.

Wade.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please



-- "Anything but Ordinary" by Avril Lavigne.

· my ·
· [link|http://staticsan.livejournal.com/|blog] ·
· [link|http://yceran.org/|website] ·
     After some MySQL clues. - (static) - (4) - May 16, 2007, 09:14:39 PM EDT
         What I'd do - (drewk) - (3) - May 16, 2007, 11:07:16 PM EDT
             I approached that from another direction. - (static) - (2) - May 17, 2007, 12:09:44 AM EDT
                 Re: I approached that from another direction. - (dws) - (1) - May 17, 2007, 01:41:19 AM EDT
                     FORCE INDEX is new to me. - (static) - May 17, 2007, 08:40:14 AM EDT

Like a flaming ant farm, only less organized.
32 ms