Forcing a Merge

If response time for queries begins to slow down, you need to free resources by combining indexes. From time to time, you need to combine smaller indexes into larger ones to free space both in memory and on disk and to resolve queries quickly. To merge smaller indexes, you need to force a merge. For more information about merges and types of merges, see Merging Indexes.

1. In the left frame of MMC, select the catalog where you want to merge indexes.
2. On the Action menu, select Merge.
3. When the Merge catalog? dialog box appears, click Yes.

See the Indexing page for details about indexing.

If you prefer, you can merge indexes by running an .ida script with the following tag:

CiAdminOperation=ForceMerge

Note   Master merge is potentially a long, CPU-intensive activity. Query execution may visibly slow during master merge. Consider displaying an extra confirmation page before running the script itself.

© 1997 by Microsoft Corporation. All rights reserved.