Re: Bigger blocksize on index TBS

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

"Helma" <helma.vinke_at_hotmail.com> wrote in message news:8a3ea588-ab6a-42ea-b635-19fff25414fd_at_f47g2000hsd.googlegroups.com...
> 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