These data-navigational instructions are commonly called access paths.
- A heavy burden is removed from the programmer by empowering the DBMS to determine the optimal access path to the data. Because the DBMS better understands the state of the data it stores, it can produce a more efficient and dynamic access path to data.
- SQL also uses a free-form structure that makes it very flexible.
- Finally, SQL’s ability to operate on set of data with a single line of code.