Memory mirror for read-only tables?
Hi,
I'm facing the following challenge: I have a couple of fairly large tables (~15 million rows that each contain 3 columns: 1 BIGINT, 1 INT and 1 FLOAT) and I need to significantly improve the read performance (Select commands need to improve by factor 20 to 30).
As those tables are read-only (i.e. they contain "expert" values that will never be changed), my best guess to improve the performance is to create a stored routine that will automatically mirror the concerned tables in MEMORY tables (not sure yet how to do this).
Would this approach make sense? Any better ideas?
Also: while the BIGINT column is the primary key, I'm using the INT field as condition in my Select commands (each returning ~5000 rows). Hence I created a BTREE Index for this column. How should I decide between BTREE and HASH or other options?
Many thanks!
Thomas
Subject
Views
Written By
Posted
Memory mirror for read-only tables?
4727
August 11, 2009 05:43PM
2078
August 11, 2009 10:05PM
2079
August 12, 2009 02:31AM
1836
August 12, 2009 07:56PM
1698
August 13, 2009 03:15PM
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.