SQL Server / SSMS / Expanding Tables List Query

Usually I do not even notice this query working in the background, since this operation is quite fast. But recently I end up working with a customer having DB with 150K tables, and expanding table list operation can be really slow and expensive.

Here is the code:

Query plan:

Similar Posts:

Leave a Reply

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