vinceb
forstie
/ Largest MTIs in use today.sql
Created
October 27, 2020 17:59
Maintained Temporary Indexes (MTIs)... everyone has them, but they're similar to building a house on sand... your foundation for performance is not rock solid. Use this Gist to gain some insight into this topic!
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Gist: Largest MTIs in use today | |
| -- | |
| -- Use SQL to understand where Maintained Temporary Indexes (MTIs) are being used, and more... | |
| -- | |
| -- | |
| -- | |
| -- Find the tables with the 10 largest MTIs | |
| -- |