Re: merge performance problem

[KimSeong Loh]

when you say not good enough, what is the execution time and what is the count(*) value that you get?

Also, what does EXPLAIN tells you.

Maybe some statistics will help

select count(*) from a_merge a where a.calldate >= '2007-11-20' AND a.calldate <= '2007-12-03 23:59:59'

select count(*) from a_merge;

select count(*) from b_merge;

With the millions in a table and hundreds in b table, maybe using straight join b join a might help.