About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
29 April 2025
Article
Manage your Maintained Temporary Indexes (MTIs)
The SQL optimizer uses Maintained Temporary Indexes (MTIs) to run queries smoothly. But too many MTIs can exhaust temporary storage. With the right information and tools, you can assist the optimizer and prevent system outages.







