Rebuilding Microsoft SQL Server Clustered Indexes for a Siebel Upgrade

Environments: Development, Test and Production.

Databases: MS SQL Server only..

Platforms: Windows only.

If you have large tables that you use extensively (such as S_EVT_ACT, S_CONTACT, S_OPTY, S_OPTY_POSTN, S_ORG_EXT), then use the Microsoft SQL Server create index command with drop_existing clause to rebuild large tables with high fill factor (60%-70%).