Upgrade Guide > Preparing an MS SQL Server Database for a Siebel Upgrade >

Rebuilding MS SQL Server Clustered Indexes for a Siebel Upgrade

Upgrades: All Siebel upgrades.

Environments: Development, production test, production.

Databases: MS SQL Server only.

Platforms: Windows only.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

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