Home » RDBMS Server » Server Administration » Larger Blocksize for INDEXTABLESPACE (
Larger Blocksize for INDEXTABLESPACE [message #336623] Mon, 28 July 2008 07:29 Go to next message
Messages: 36
Registered: July 2008

My DB blocksize is 8K.

If I create a larger blocksize (say 32K) for index tablespace will it be helpful in faster retrival?


Re: Larger Blocksize for INDEXTABLESPACE [message #336637 is a reply to message #336623] Mon, 28 July 2008 08:35 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your application and the statements it execute.
In addition, you have to configure and manage a cache for this block size and so have less space for the default cache.

Previous Topic: Extend filesystem - External device
Next Topic: how to reduce the database size after dropping the schema
Goto Forum:

Current Time: Sun Aug 20 03:07:41 CDT 2017

Total time taken to generate the page: 0.01300 seconds