Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 14:09:24 GMT

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

Hi syamala,

I observed following differnces.

Online Archive-

Eariler verison, during archive(Back up) of data. The TD will not be available online. But in TD12, we can query from TD but performance may be slow depends on your query complexity.

Multilevel Partitioned Primary Index-

This MPPI is the PPI with subpartition. It must have minumum of 2 and max of 15 of subpartitioning.

Collect stats imporvement-

The have added extrapolated stats(when a query references a date beyond the range with collected statistics, the database will automatically extrapolate the collected statistics to create an accurate plan)

The max number of intervals for a statistics on a index/column is increased from 100 to 200.

For complete set of differences please refer the TD documents and share your observations too.

Thanks

John

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