Query language performance
Relational databases are queried in SQL.
SQL queries are non-procedural.
Query optimization
- A complex query can have thousands or millions of possible implementations.
- A good plan can be many orders of magnitude faster than a bad
plan. E.g., 0.1 sec vs. 3 hours.
|