I was having at look at the query plan operators today in preparation for a talk I will be giving on Plan execution and cache and noticed that some of the operators present are not used in SQL Server 2016, most notable the “Bookmark Lookup” operator.
From database engine reference online the following is stated:
“Bookmark Lookup is not used in SQL Server 2016. Instead, Clustered Index Seek and RID Lookup provide bookmark lookup functionality. The Key Lookup operator also provides this functionality.”
Query plan operators not used in SQL Server 2016: Bookmark Lookup