Query Optimizer,”concerned with the rearrangement & possible reordering of operations, eliminating redundancies, & using efficient search algorithms during executionconsults the system catolog for stats & physical info about the stored data, generates executable code that performs the necessary operations for the query
& makes calls on the runtime processor”