Re: Merge table performance
Hi KimSeong,
I’ve tested this again by removing the LIMIT clause from each query and now get the results that I was expecting;
Query 1 (without LIMIT 1) on base table 1 returns in 13 seconds
Query 1 (without LIMIT 1) on merge table returns in 13 seconds
Query 2 (without LIMIT 1) on base table 2 returns in 26 seconds
Query 2 (without LIMIT 1) on merge table returns in 26 seconds
Note that sorting the data by ORGANISATION_ID, before loading the data into the table, (the indexes are already sorted) has a dramatic affect on the queries which use a LIMIT clause.
Query 1 on base table 1 returns in 0.01 seconds
Query 1 on merge table returns in 0.01 seconds
Query 2 on base table 2 returns in 0.01 seconds
Query 2 on merge table returns in 14 seconds
Many thanks for your help here.
Regards,
Alastair.
Subject
Views
Written By
Posted
9839
July 19, 2005 09:13AM
5105
July 19, 2005 11:37PM
4834
July 20, 2005 12:58AM
Re: Merge table performance
4731
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.