|
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: 767
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 |
|
|
|
|
