Searchable Query

This session will teach you how to define basic things about Query Optimisation and 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. You will learn how to detect and reduce the logical reads to get faster query.

Searchable query Query Optimisation Index Seek