What Is Collect Statistics?

1.	What Is Collect Statistics?
Answer» Collects demographic DATA for one or more columns of a table, hash index, or join index, computes a statistical profile of the COLLECTED data, and STORES the synopsis in the data dictionary. The OPTIMIZER uses the synopsis data when it generates its table access and join PLANS. Collects demographic data for one or more columns of a table, hash index, or join index, computes a statistical profile of the collected data, and stores the synopsis in the data dictionary. The Optimizer uses the synopsis data when it generates its table access and join plans.

Answer»

Collects demographic DATA for one or more columns of a table, hash index, or join index, computes a statistical profile of the COLLECTED data, and STORES the synopsis in the data dictionary. The OPTIMIZER uses the synopsis data when it generates its table access and join PLANS.

Collects demographic data for one or more columns of a table, hash index, or join index, computes a statistical profile of the collected data, and stores the synopsis in the data dictionary. The Optimizer uses the synopsis data when it generates its table access and join plans.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Basic Rules That Define How Pi Is Defined In Teradata?
What Is A Common Data Source For The Central Enterprise Data Warehouse?
What Are The Enhanced Features In Teradata V2r5 And V2r6?
What Is An Optimization And Performance Tuning And How Does It Really Work In Practical Projects?
Teradata Performance Tuning And Optimization?
Can We Load A Multi Set Table Using Mload?
Can I Use "drop" Statement In The Utility "fload"?
In A Table Can We Use Primary Key In One Column And In Another Column Both Unique And Not Null Constrains.if Yes How?
What Are The Types Of Tables In Teradata ?
Can You Recover The Password Of A User In Teradata?