BLOCK SIZE ...... FSP

General

BLOCK SIZE ...... FSP

Heloo Teradata Gurus

Need your inputs on FSP setting to avoid block splits.

In the first place is there any rule of thumb that what blocksize should be we keep for tables that are static, Tables that are frequently updated/inserted/deleted and tables that are huge and at times undergoes a change.

Similarly what should the %FSP for those tables?

How do we identify consistent BLOCKSPLITS or CYLINDERSPLITS? what should be the approach for negating it.

Appreciate your response and your valuable inputs..

Many thanks

NZ_2_TD