View Single Post

   
  #2 (permalink)  
Old 05-02-2008, 05:04 AM
Serge Rielau
 
Posts: n/a
Default Re: db2rbind after runstats?

Patrick Finnegan wrote:
> Is it still necessary to do perform a bind after runstats in DB2 9?
> runstats
> reorg
> runstats
> db2rbind

The whole idea of static SQL is that it does not change plans on you
unless you want it to. So I wouldn't call it necessary. But required IF
you want to pick up the new stats.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Reply With Quote