Archives of the TeradataForum

Message Posted: Thu, 27 Mar 2008 @ 15:54:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

If the size of my table is very big like 500 GB.

I collected the statistics using sample like below queries for example:

     COLLECT STATISTICS USING SAMPLE ON Employee COLUMN (Last_Name);
     COLLECT STATISTICS USING SAMPLE ON Employee COLUMN (First_Name);
     COLLECT STATISTICS USING SAMPLE ON Employee COLUMN (Last_Name, First_Name);

Now again I collect the statistics through this command:

     COLLECT STATISTICS ON Employee;

So, it will collect the statistics with SAMPLE DATA OR it will go through with full table scan for all records.

Regards

Rahul Dharmawat

	<Prev	Next>		<<First	<Prev	Next>	Last>>