Re: Merge table performance
I guess it is the LIMIT 1.
Remove the LIMIT 1 and test again.
With LIMIT 1 , MySQL will stop once it found 1 row for your result based on your query.
The order of the tables in the MERGE will probably also determine which table to search first, so the query returns faster when it searches and fount the 1 row in the first table. When it cannot find the 1 row after scanning the first table, it will then have to start to search the 2nd table. So, yuo see a difference in performance with different order.
Subject
Views
Written By
Posted
9848
July 19, 2005 09:13AM
Re: Merge table performance
5114
July 19, 2005 11:37PM
4840
July 20, 2005 12:58AM
4738
July 21, 2005 01:38AM
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.