wrote in message news:[EMAIL PROTECTED]
> Hello.
>
> I've checked this and found that ANALYZE table really doesn't work, but
> OPTIMIZE table made its work. In case it won't help you send to list
> complete definitions of you tables and queries.
>
>
> Allan
well. Have a look here:
>http://dev.mysql.com/doc/refman/5.0/en/how-to-avoid-table-scan.html
>
>
>
> Allan Miller wrote:
> > In MySQL 4.1.11, if you create two temporary tables with non-unique indices
> > as part of the CREATE TEMPORARY TABLE statement,
then
>
after the addition of data makes a
difference on SELECT performance?
Allan Miller
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
