dbms feature that identifies ways to process a query and chooses the fastest one
dbms feature that identifies the possible ways to execute the query and chooses the fastest query plan
a type of expert system that attempts to figure out the most efficient way to answer a query before actual execution