Now, I have a question. Are secondary indexes maintained in block cache?
When I describe one of my indexes, I see - IN_MEMORY => 'false', BLOCKCACHE =>
'true'
Does this mean that the index does not reside in memory? Should I explicitly
set IN_MEMORY=true when I create index?
Thanks,Sumit
From: Sumit Nigam <[email protected]>
To: "[email protected]" <[email protected]>; Sumit Nigam
<[email protected]>
Sent: Thursday, November 5, 2015 2:42 PM
Subject: Re: Block Cache
Sorry, do not bother. I figured out - can be done by specifying
BLOCKCACHE=false at create table time.
From: Sumit Nigam <[email protected]>
To: Users Mail List Phoenix <[email protected]>
Sent: Thursday, November 5, 2015 1:58 PM
Subject: Block Cache
Hi,
Is there an easy way to completely turn off block cache for a specific table at
table creation time itself? Something like, CREATE TABLE X ( ..... )
BLOCK_CACHE=FALSE;
I could likely hint the queries during read time, but setting I'd like to turn
it off completely.
Thanks,Sumit
