Skip to Content
0
Former Member
Dec 14, 2010 at 08:58 PM

Limit size for index tablespaces

67 Views

Hello,

We have a lot of performance issues with queries selecting from tables whose indexes blong to the tablespaces BTABI

This tablespaces is the second biggest one in our system

1-is there any relation between size and performance?

2- Does the size of the index tablespace impact the bufferisation process?

3- is there any maximum for the size of index tablespace above which bufferization won't work

Thanks for your help

Meher