At 11:34 AM 2/14/2004, Are Pedersen wrote:
I am running OPTIMIZE table and ANALYZE table each night on all tables and
databases.
Shouldn't the explain statement tell me what's going on...it says
9,1,1,7,1,6,1 on rows, and multiplied up its not much. 378 rows to examine
should run fast.
Are,
I am running OPTIMIZE table and ANALYZE table each night on all tables and databases.
Shouldn't the explain statement tell me what's going on...it says 9,1,1,7,1,6,1 on rows, and
multiplied up its not much. 378 rows to examine should run fast.
mos wrote:
At 04:21 AM 2/14/2004, you wrote:
Thi
At 04:21 AM 2/14/2004, you wrote:
This SQL takes 2 minutes to run on one database, and seconds on another.
The tables has the same indexes, but different number of rows in them.
It could be you have deleted a lot of rows from the table and therefore it
is fragmented. You may want to try optimizing
