The database system internally transforms SQL statements to speed their processing. The SQL Optimizer then selects the best access strategy.
How you configure your database instance will substantially influence its performance.
See also:
Concepts of the Database System, Performance
SAP Note 819641