Archives of the TeradataForum
Message Posted: Thu, 27 Mar 2008 @ 15:54:46 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|