sql server - Bind SQL query to actual objects (Algebrizer) ,does relational engine need Storage engine's involvement -
background
i have been reading ms sql server query processing internals , of them explains, during execution phase (post parsing & optimization) relational engine talks storage engine data access.
but algebrizer, bind sql text actual objects, need system catalog, believe lies within resource database.
questions
in case , relational engine not need storage engine's during parsing phase (ahead of execution phase)?!
if yes, like, every query execution, there 2 phase of disk/buffer pool reads?
- to parse (then optimize) ,
- to execute?
ps: don't think please clarify confusion
cant attach/link query processing picture (don't have enough points link).
Comments
Post a Comment