MySQL Forums
Forum List  »  Merge Storage Engine

Re: merge performance problem
Posted by: KimSeong Loh
Date: December 04, 2007 07:54PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
11771
December 03, 2007 01:04PM
6460
December 03, 2007 06:42PM
6671
December 04, 2007 04:33AM
Re: merge performance problem
6222
December 04, 2007 07:54PM


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.