These features were introduced in IBM Informix Dynamic Server, Version 9.21.
| Features | Reference |
|---|---|
| ANSI outer join | Using Join Filters and Post-Join Filters |
| RENAME INDEX | Automatic Reoptimization |
| Nonlogging (RAW) tables | Loading and Unloading Tables |
| SQL statement cache enhancements | Virtual Portion |