Archives of the TeradataForum
Message Posted: Tue, 08 Dec 2009 @ 15:20:37 GMT
Suppose i have a query in the following format:
select * from tbl where col1='value'
The column: col1 is not part of any index in the table: tbl. There are no stats collected on the column: col1
Since the column: col1 is not part of any index, the above query will be an ALL-AMP operation. In other words a full table scan. So my question is:
Theoretically how will collecting stats on this column help? What will be performed differently by the optimizer after collecting stats to make the data retreival quick?
Thanks in advance for your suggestions.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|