Re: Bigger blocksize on index TBS

From: <>
Date: Mon, 14 Jan 2008 12:33:03 GMT
Message-ID: <3EIij.8796$W73.7413@trnddc04>

"Helma" <> wrote in message
> Hello everyone,
> How to investigate in advance if a bigger blocksize on an index
> tablespace will benefit performance?
> Thanks for pointers
> H.

Test it. Remember that to have an index tablespace with a different block size you have to explicitly allowate a cache for it. So if you get the cache size wrong then you either waste memory (too large) or thrash the cache.
Jim Received on Mon Jan 14 2008 - 06:33:03 CST

Original text of this message