Hi Scott, The explain time in the syscat.tables matches what is in the explain. It it the other values in the explained column (Cardinality, npages, etc) which do not match current column. The current column is correct. This is where I am still confused. Where do the values in the explained column come from.
Thanks, Mike Patterson --- Scott Saunders <[EMAIL PROTECTED]> wrote: > Mike; > Explain should be reading the system catalog. Can't > imagine where else > it could look for the data. > > Check the STATS_TIME on SYSCAT.TABLES (make sure the > timestamp on the > indexes and tables are from about the same > timeframe) and make sure that > the RUNSTATS has been executing successfully. If > STAT_HEAP_SZ is too > small, RUNSTATS can fail on specific tables. Might > want to check the > indexes too. > > Scott Saunders > > Opinions are my own and not those of my employer or > anyone else. > > -----Original Message----- > From: Michael Patterson > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2003 5:39 PM > To: [EMAIL PROTECTED] > Subject: [DB2EUG] Explain Question > > > Hi All, > > I have a question from visual explain. I explained > some dynamic sql and when I click on a table in the > explain I get statistics on the table. My > statistics > on the table are updated weekly so I know they are > current and the stats time is the same in the > explained and current columns. The current stats > contain the correct cardinality and number of pages. > > Where does the explained column get it's values and > why are they different. On one table the difference > is over 80 million rows. Any thoughts are > appreciated. > > Thanks, > Mike Patterson > > __________________________________ > Do you Yahoo!? > Yahoo! Calendar - Free online calendar with sync to > Outlook(TM). > http://calendar.yahoo.com > - > ::: When replying to the list, please use > 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to > [EMAIL PROTECTED] > *** For more information, check > http://www.db2eug.uni.cc > > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
