- Cost-based optimizer enhancements
In Oracle9i, the cost-based optimizer can recognize the CPU speed of the server machine and use this in determining the optimal execution path for an operation.
- LONGs to LOBs
Oracle9i has made it easier to use the LOB (large object) datatype and to migrate LONG datatypes to LOB datatypes.
- AnyType datatype
The AnyType datatype and its associated datatypes (AnyData and AnyDataSet) let you define datatypes that are totally outside the realm of existing Oracle datatypes.
- Character length in NLS characters
You can now specify the character length for NLS characters and, if the character set requires double-byte storage, Oracle9i will automatically make the conversion.
- XMLType
The XMLType datatype allows you to store native XML documents in an Oracle9i database.
- External tables
Oracle9i supports the definition of external tables, in which data resides outside the actual database.
- List partitioning
In Oracle9i, you can define a partition based on a list of values.
- Index organized table enhancements
Oracle9i lifts many of the previous restrictions on the operations and secondary indexes you could have for an index organized table (IOT).
Get Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
