List:Internals« Previous MessageNext Message »
From:Vasil Dimov Date:July 4 2008 4:55pm
Subject:Re: bzr commit into mysql-5.1 branch (davi:2667) Bug#21704,
Bug#33873
View as plain text  
On Fri, Jul 04, 2008 at 11:44:05 -0300, Davi Arnaut wrote:
[...]
> The documentation says that after an ALTER TABLE statement, it may be 
> necessary to run ANALYZE TABLE to update index cardinality information.
> 
> ANALYZE TABLE t1;
> Table   Op      Msg_type        Msg_text
> test.t1 analyze status  OK
> EXPLAIN SELECT * FROM t1 WHERE b LIKE 'adfd%';
> id      select_type     table   type    possible_keys   key     key_len 
> ref     rows    Extra
> 1       SIMPLE  t1      range   b       b       769     NULL    2 
> Using where
[...]

Yes, ANALYZE TABLE gives me the "old" behavior.

Thanks :)

-- 
Vasil Dimov
moc.elcaro@stripped        Software Developer @ Oracle/Innobase Oy
gro.DSBeerF@dv                Committer @ FreeBSD.org
gro.d5v@dv                    Home @ Sofia, Bulgaria

Attachment: [application/pgp-signature]
Thread