Manual Index Optimization via CREATE METAMORPH INDEX

A Metamorph index may be optimized manually simply by re-issuing the same CREATE METAMORPH [INVERTED|COUNTER] INDEX ... statement that was used to create it. Instead of producing an error noting that the index already exists - as would happen with regular or inverted indexes - the Metamorph index is re-optimized. (If the index is already fully optimized, the statement returns success immediately.)

Note that the ALTER INDEX statement (here) is an easier method of optimizing indexes.

Copyright © Thunderstone Software     Last updated: Oct 5 2023
Copyright © 2024 Thunderstone Software LLC. All rights reserved.