|
View previous topic :: View next topic
|
| Author |
Message |
theone1987
New User
Joined: 14 Sep 2009
Posts: 60
Location: Milan
|
|
|
|
hi,is there a way to make a LOAD REPLACE without resetting the statistics db2?
thank you |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
theONE,
Don't add the STATISTICS keyword to LOAD parmeters.
Why can i ask ?
Usually everybody wants their statistics to be up-to-date.
Sushanth |
|
| Back to top |
|
|
theone1987
New User
Joined: 14 Sep 2009
Posts: 60
Location: Milan
|
|
|
|
| sushanth bobby wrote: |
theONE,
Why can i ask ?
Sushanth |
tnk you...
because I need to delete and reload a table. |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
depends on what "the statistics db2" is
if you mean the statistics in the catalog, then sushanth is right.
at least if you didn't drop and recreated the table.
if you mean RTS or Real time statistics, then : NO |
|
| Back to top |
|
|
|
|
