The process of query optimization is very computationally expensive. For this reason, SQL Server stores execution plans ... In the database you could create filtered indexes.