Message-Id: <10499.105755@fatcity.com> From: "Andrey Bronfin" Date: Thu, 23 Nov 2000 20:28:08 +0200 Subject: Segments storage in memory This is a multi-part message in MIME format. ------=_NextPart_000_0307_01C0558B.E48C7800 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear DBAs ! Could U please clear the following for me : 1) What's the difference between creating a table with storage ( = BUFFER_POOL KEEP) vs . creating a table with CACHE specification ? 2) Is it possible to create an index specifying CACHE ? ( I did not = succeed so far and i don't have a doc to look at ) . Thanks a lot in advance ! ------=_NextPart_000_0307_01C0558B.E48C7800 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear DBAs !

Could U please clear the following for = me=20 :

1) What's the difference between = creating a=20 table with storage ( BUFFER_POOL KEEP) vs . creating a table with = CACHE=20 specification ?

2) Is it possible to create an = index=20 specifying CACHE ? ( I did not succeed so far and i don't have a doc to=20 look at ) .

Thanks a lot in advance !