Optimize Your SQL Queries with Schema Names August 3, 2018 SQL Server, by design, caches query plans for queries. For reuse of cache, the best practice would be to include the schema name in the query. For example: select *