22-25 April 2026

Searchable query

Proposed session for SQLBits 2026

TL; 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