:[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 Miller wrote:
Hi Gleb,
Thanks for the quick response
or 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]
/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
insert several hundred (or thousand) rows, a subsequent SELECT using a JOIN
between the two tables