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
