https://www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/index-selection-and-the-query-optimizer/
While we all know that the Query Optimizer uses Indexes to produce better execution plans, we don't all know exactly which indexes will give the best results....
index selectionquery optimizersimpletalk
https://docs.oracle.com/en/database/oracle/oracle-database/21/tgsql/query-optimizer-concepts.html
This chapter describes the most important concepts relating to the query optimizer, including its principal components.
query optimizerconcepts
https://support.microsoft.com/en-us/topic/kb4051361-optimizer-row-goal-information-in-query-execution-plan-added-in-sql-server-2014-2016-and-2017-ec130d21-1adc-3d3d-95a5-cdb075722269
Discusses that Cumulative Update 3 adds new "EstimateRowsWithoutRowGoal" query execution plan attribute to SQL Server 2014, 2016 and 2017.
query execution planoptimizerrowgoalinformation