On Mon, Sep 29, 2003 at 09:14:06PM -0700, Kevin wrote:
>
> I suspect it uses some algorithm to 'guess' the number of rows, and this
> usually gives a lower number to bigger indicies?
Did ANALYZE table help at all?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMA
Anyone know how the index chooser works, and why it is often so bad?
For example, with the following query:
SELECT lid,brief,title FROM poems left join poets on poems.mid =
poets.mid WHERE poems.mid =9365 ORDER BY created DESC LIMIT 0,10
With an explain of:
*** 1. row **
