SQL Server / SSMS / Expanding Indexes List Query

Same as in previous posts examples Expanding Tables List Query and Expanding Columns List Query I usually do not notice this type of queries working in the background. But recently I end up working with a customer having DB with over 500K indexes, 150K tables and expanding indexes list operation can end up being slower than usual.

Here is the code:

Query plan:

Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *