Hi All, I hate to bother you, but I was hoping that you might be able to lend a hand. I am currently looking to hire a DB2 DBA in the Northern Virginia area for a 3 month contract. This person will test UDB Version 8.1 in an AIX environment. They will also be responsible for the layout of a database for B2B project and to support its initial deployment. They should be familiar with DB2, Unix, AIX and should be familiar with the duties of a Systems Administrator. If you are interested please contract me at (703)-256-2000.
Thank You very much! Leigh Worden -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Patterson 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 - ::: 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
