MySQL Forums
Forum List  »  Optimizer & Parser

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

Options: ReplyQuote


Subject
Views
Written By
Posted
index choose and analyze table
3262
September 11, 2006 04:37AM
2548
September 14, 2006 08:25AM
10689
September 14, 2006 10:38AM
3283
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.