Refine etx indexes
This section describes ways you can refine your etx index to improve the performance of searches.
- Estimate the size of an etx index
This section describes the factors that might make your etx index larger than it needs to be and consequently cause your queries to run slower than they need to run. - Fragment indexes
Fragmenting indexes typically improves performance of text searches, particularly on multiprocessor computers. However, improperly fragmented indexes can degrade performance of certain queries. Carefully consider how your likely data and your likely queries might be affected by fragmentation. - Share etx indexes
The etx indexes are to be left open to improve performance of subsequent queries that use the index. - Reclaim unused index space
You can improve performance by reclaiming unused index space.
Parent topic: Administration