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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 16 days, processed 586,152,545 queries (405/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]