All Forums Database
20 Jan 2012
DDL review

Before any new DDL is installed in our Prod env, it goes through a DDL review.

Can any1 plse. help us with what all things are considered in this approach??

How to plan if Partitions are needed, use of secondary index, Primary Index, etc.

Also, what is MergeBlockRatio??

 

Appreciate your Inputs:)

 

Teradata NooB.
ppad001 18 posts Joined 06/11
21 Jan 2012

I am supposing your table is a final table.

Looking at the datamodel can give you a better idea of the indexes u need to create for the table.The creation of partition column always is not necessary, its only required if there is a range of values expected for a critical column.

Hope this helps you a little.

You must sign in to leave a comment.