Summary (cont’d)
Nulls (unknown or nonexistent) force a 3-valued logic and odd behavior
Many alternative ways to write a query; optimizer should look for most efficient evaluation plan.
- In practice, users need to be aware of how queries are optimized and evaluated for best results.
SQL3 (SQL:1999) adds nested relational and object-oriented features to SQL (later in course)