Rebind after ALTER BUFFERPOOL ?

Hello

Rebind after ALTER BUFFERPOOL ?
Hi all ,

I have a question : Do i have to rebind after important changes in
Bufferpool ? (Moving a Tablespace from another BP ..., changing sizes) -
My response is No , but i am not sure ...

Thanks



Rick Davis

Re: Rebind after ALTER BUFFERPOOL ?
(in response to Hello)
<PRE>The Optimizer use BP sizes, CPU(s), memory, etc during optimization.



Myron Miller

Re: Rebind after ALTER BUFFERPOOL ?
(in response to Rick Davis)
Only if the sizes fo the impacted BPs are drastically different or one was
extremely small. Normally, with reasonable size BPs NO. The optimizer checks
for a certain minimum size and as long as the BPs are above that size whether
its 10000 or 50000 won't make any difference to the optimizer.

Myron
--- Christophe Radier <[login to unmask email]> wrote:
> Hi all ,
>
> I have a question : Do i have to rebind after important changes in
> Bufferpool ? (Moving a Tablespace from another BP ..., changing sizes) -
> My response is No , but i am not sure ...
>
> Thanks
>
>
>
>
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com