Version 10.0 includes several new features that help you monitor and improve the overall performance of your database server.
| New Features | Reference |
|---|---|
| A new command to use to set or modify the OPTCOMPIND value within a session | Information on the SET ENVIRONMENT OPTCOMPIND command in OPTCOMPIND. |
| A mechanism for creating external optimizer directives for use as temporary solutions to problems when you do not want to change SQL statements in queries | External Optimizer Directives and Creating and Saving External Directives. |
| New SQL statements to use in an online environment to create and drop an index without having an access lock placed over the table | Creating and Dropping an Index in an Online Environment |
| Two new configuration parameters that you can use when you have fuzzy checkpoints and need faster recovery performance | Configuration Parameters That Affect Rollback and Recovery and FAST_RESTART_PHYSLOG and FAST_RESTART_CKPT_FUZZYLOG |
| An increase in the size of segments for shared memory | SHMADD and the IBM Informix: Dynamic Server Administrator's Reference |
| A new configuration parameter to use to increase the amount of sort memory that is a available for a query that is not a parallel database query. | More Memory for Queries with Hash Joins, Aggregates, and Other Memory-Intensive Elements |
| Functionality for specifying the page size for a standard or temporary dbspace when you create the dbspace. | Setting the Size of the Buffer Pool, Logical-Log Buffer, and Physical-Log Buffer, and the IBM Informix: Dynamic Server Administrator's Guide |