Filter by Engine When Scanning System Tables to Improve Efficiency

Why it matters

This feature addresses the inefficiency of scanning all tables in system.tables regardless of their engine type, which can lead to unnecessary and potentially time-consuming connections. By filtering by engine, users can speed up queries and reduce resource usage.

How to use it

Users can apply the filter by specifying the desired engine type in the WHERE clause of queries against system.tables. For example:

SELECT * FROM system.tables WHERE engine = 'MergeTree'