Re: How to load whole table in memory?
Right, but anyway you can try out if it helps in your application. A possible way to start experimenting with is CREATE TABLE new_table ENGINE=MEMORY AS SELECT * FROM old_table; If this improves the performance for you, you can modify the select statement for your needs.
Subject
Views
Written By
Posted
19778
April 18, 2005 03:22AM
12291
April 20, 2005 10:40PM
Re: How to load whole table in memory?
10567
May 06, 2005 07:12AM
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.