one of the current restrictions of archive tables is that they do not support any indexes, thus necessitating a table scan for any select tasks. archive tables, however, are supported by the mysql query cache, which can dramatically reduce response times for archive table queries that are repetitively issued. mysql is examining index support for archive tables in upcoming releases.