Searchable query
Proposed session for SQLBits 2026TL; DR
This session will teach you how to define a searchable query. A SEARCHable query is from WHERE clause for which the query execution plan contain an [Clustered] Index Seek operator instead of the opposite context where the execution plan contains [Table|Clustered[Index]] Scan operator if there is an appropriate index available.
Session Details
This session will teach you how to define a searchable query. A SEARCHable query is from WHERE clause for which the query execution plan contain an [Clustered] Index Seek operator instead of the opposite context where the execution plan contains [Table|Clustered[Index]] Scan operator if there is an appropriate index available.
3 things you'll get out of this session
Searchable query
Query Optimisation
Index Seek