View previous topic :: View next topic
|
Author |
Message |
girishbs13
New User
Joined: 11 Nov 2011 Posts: 24 Location: India
|
|
|
|
Hello All,
Does DB2 explain take into account the amount of Data present in Tables?
If I have less data in my test region compared to the production enviorment, will the explains against each enviorment produce different results ?
Thanks,
Sabari Girish |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
Yes. That's why you hear the suggestion to get the latest RUNSTATS so often. |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
It you have the knowledge and the necessary authority the catalog stats can be manipulated to simulate, in a test environment catalog, what the production table will look like after it is populated. This authority is probably restricted to your local DBA team. |
|
Back to top |
|
|
girishbs13
New User
Joined: 11 Nov 2011 Posts: 24 Location: India
|
|
|
|
thanks for the information |
|
Back to top |
|
|
|