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..