The configuration of your database has a significant impact on performance.
Internally, the database system transforms SQL statements to speed up their processing. The SQL optimizer then selects the best access strategy.
Analyzing Database Performance
Analyzing Database Performance: Overview
Database Administration in CCMS,
Performance Analysis in CCMS
819641 (FAQ: MaxDB Performance)