Automatic query optimisation means that the:

a$.$

optimisation takes place at compilation time by the programmer.

b$.$

database access strategy is defined when the program is executed.

c$.$

optimisation process is scheduled and selected by the end user or programmer.

d$.$

DBMS finds the most cost$-$effective access path without user intervention.