Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Diff bt V2R6 and TD12
From:   Jepamony, Johnpaul

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023