Archives of the TeradataForum

Message Posted: Wed, 04 May 2011 @ 12:04:40 GMT

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

1) u can check this is dbc.indices or dbc.IndexStats where indextype='q'

2) where IndexStatistics(column in dbc views) is null

Yes,you should

PARTITION. This tells the optimizer how many partitions are empty, and how many rows are in each partition. This statistic is used for optimizer costing.

The partitioning column. This provides cardinality estimates to the optimizer when the partitioning column is part of a query's selection criteria.

Thanks & Regards,

Minakshi Swami

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