Monday 5 September 2011

Stats in Teradata

Collect stats is a mechanism which helps optimizer to get the least cost execution plan for each requested query.

Collect statistics on table
collect stats on TABLE_NAME;

Collect statistics on column of table
collect stats on TABLE_NAME column(COL1);
collect stats on TABLE_NAME column(COL2);

To get detail about statistics of a table
Help stat DBName.TableName;


3 comments:

  1. Thanks for Information Teradata Online Training is one of the most emerging technologies in market. As more and more organization are moving their data warehouse in Teradata database, so the demand of Teradata Professionals are high. We at TeradataTech started giving online training sessions for all folks who are interested in learning this technology. People who are interested in learning the basics and advance features of Teradata Development can benefit from this training.

    ReplyDelete
  2. well this was very nice article and very good information for Teredata learners i was really satisfied see this information we also provide Teredata Online Training

    ReplyDelete