index choose and analyze table
Posted by:
Jens Schanz
Date: September 11, 2006 04:37AM
Hi,
i've a MySQL-5.0.1 server and a database which data is sotred in an InnoDB-Tablespace.
Through the whole day, i've a lot of inserts and updates. Nightly I run a report which 5 or 6 selects.
After a reboot, the explain shows me, that for all questions an index will be used. If i'll wait a few hours the optimizer choose a full table scan instead the use of an index. After an anaylze table, the index will be used again.
Is there any possibility to watch a value, if the query would use an index or not (I think the statistics are optimized for the index and update statements)?
Brgds,
Jens
Subject
Views
Written By
Posted
index choose and analyze table
3279
September 11, 2006 04:37AM
2559
September 14, 2006 08:25AM
10713
September 14, 2006 10:38AM
3293
September 19, 2006 04:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.