InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:16:39 GMT20http://www.teradata.com/teradataforum/Topic9470-5-1.aspxCheckout for a wonderful article by Carrie ballinger on Collect statistics. It might be available on Teradata.com site or Teradata Magazine site. Wealth of information is presented in that.Mon, 29 Oct 2007 09:19:23 GMTramakrishna_vedantamhttp://www.teradata.com/teradataforum/Topic9470-5-1.aspxHi Rahul,It is not required to collect statistics on all tables in the database.Collecting statistics on the columns in a large table, where the non-index columns is frequently used in where clause and joins will help in query performance.Regards,BalamuruganMon, 29 Oct 2007 02:24:28 GMTBalamurugan Bhttp://www.teradata.com/teradataforum/Topic9470-5-1.aspxhello allis it required to take COLLECT STATISTICS on all the tables in the database?if no pls tell me some tips on which type of tables should i take COLLECT STATISTICSand on which type of columnsSat, 27 Oct 2007 01:20:44 GMTRahul