Re: Bigger blocksize on index TBS
Date: Mon, 14 Jan 2008 12:33:03 GMT
"Helma" <helma.vinke_at_hotmail.com> wrote in message
> Hello everyone,
> How to investigate in advance if a bigger blocksize on an index
> tablespace will benefit performance?
> Thanks for pointers
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