I have an update query based on three tables. It runs in <0.020 sec. However, after I compact the database, this same query takes >2.000 sec to run. How can I redesign the query so that it runs in < 0.020sec after compaction?
If you think you can answer this question, please send me your email address so I can email you the database (<4MB, zipped).