ducon (1/4/2010)
Hi there,I would love to find a book dedicated to the query optimizer that explains how it works, how it chooses certain plans over others etc.
Greg
ISQL Server Execution Plans[/url]
It does give a background of the query optimizer and goes into detail about execution plans. Don't know if it is the detail you are looking for. Gail is right in that the true "internals" of the query optimizer are Microsoft trade secrets probably and not available to public. I have never come across anything detailed, but Grant's e-book is a good start.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton