What's new for IBM i 7.1
The following information was added or updated in this release of the information:
- Global Statistics Cache
- Encoded vector index index-only access
- Encoded vector index symbol table scan
- Encoded vector index symbol table probe
- Encoded vector index INCLUDE aggregates
- Array unnest temporary table
- Adaptive Query Processing
- Health Center SQL procedures
- Sparse indexes
- View index build status
- Improve concurrency by avoiding lock waits
- Using field procedures to provide column level encryption
- SYSTOOLS
What's new
The following revisions or additions
have been made to the Performance and query optimization documentation
since the first 7.1 publication:
- April 2016 update :
- An additional query option was added to QAQQINI : ALLOW_EVI_ONLY_ACCESS. For details, see QAQQINI query options
- May 2015 update :
- Additional options were added to the QAQQINI query option Memory_Pool_Preference. For details, see QAQQINI query options
- October 2014 update:
- The database monitor topic has been updated: Monitoring your queries using the Database Monitor
- The SQL Plan Cache topic has been updated: Optimizing performance using the Plan Cache
How to see what's new or changed
To help
you see where technical changes have been made, this information uses:
- The
image
to mark where new or changed information begins. - The
image
to mark where new or changed information ends.
To find other information about what's new or changed this release, see the Memo to users.
