DDL review

Database
Enthusiast

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:)

1 REPLY
Enthusiast

Re: DDL review

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.