Archives of the TeradataForum

Message Posted: Tue, 08 Dec 2009 @ 15:20:37 GMT

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

Hello All,

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.

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