Re: Q:Keeping a table in memory for speed

From: Martin Schroeder <ms_at_dream.hb.north.de>
Date: 1997/05/03
Message-ID: <jVnazAcJBh108h@dream.hb.north.de>#1/1

In <336A6195.1BBC_at_citicorp.com> Simon Spencer <Simon.Spencer_at_citicorp.com> writes:
>I dont suppose anyone can tell me how to make a table or group of tables
>memory resident?

alter table <tablename> cache;

Best regards

Martin

-- 
               Martin Schr"oder, MS_at_Dream.HB.North.DE
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.3ia

mQENAzNGllYAAAEIANjfO7elGs1++9PC0W5UPP8QZeIGKJUPuEhurLjagof0gPnI
KiZQwZf467l2WdX/ZDAk93Q73q3zNtQBTRxF/rvH+yvnx0QFgHtseixqIMzY3M1w
3EI7qjb3U8G2hHCgRXXODiaBu1y0cSAgCl+bKmSL6FjbF13Ho7coX2N9G4zGJ3hq
w/yaypTq9X8NFSznt2cd0wusi1IUDqd62f4oQPFAR0z/cqKFIrObHL83oCXuMc/6
+5YkZtyN/ZLYynDFCqZH25wfp6dr44UxAk2Uth2nRHEpvluDvTGZWrHpeLhVuUNN
LGm0zqb5t1EJAwFZZ1uIpN7g48/6Ozt6/67N/oUABRO0J01hcnRpbiBTY2hyb2Vk
ZXIgPE1TQERyZWFtLkhCLk5vcnRoLkRFPokBFQMFEDNGllY7O3r/rs3+hQEBFGUH
/0Y3uqegTJ6xSj1bn7QgyVD1ZfTOjWNsZgif3V/EQZAi3QBm1Ne5QrB1MyXHN5nt
+qXllBrJN2q5jv5yjbV+JdQc/o+2CiPTdUUrzCLHE8CC1c22mOQvxDGilFNzpCmq
SRTyKTX4BJRB4prSkx1NBaALqVCT5qamDclbJCazkB76vYkPnVbwvznlllFHPdVp
9QdbT50Hli/qYPkI0gxBxi/B4KNpAJQ6EswOLK3thMrfFO3RWbCl9bPE+nt+gJ8E
nqQXjIwdLYg2g6MZIuX7FtAdl4WO2pYSKjsEsGTh4aca+5hLWKoKyaV11ObLOdO5
afFgU88RIigZJYIzwRJgCtw=
=67Ih
-----END PGP PUBLIC KEY BLOCK-----

Received on Sat May 03 1997 - 00:00:00 CDT