Introduction
Software
Installation
Concepts
and Design
Designing
Applications
Omnidex
Environments
SQL
Reference
Omnidex
API's
Utilities
Interfaces
Performance
Guide
Troubleshooting
Guide
Appendix
|
SQL Optimization
- Optimization and broader support of nested queries in
criteria
- Optimization and broader support of set operations -
UNION, INTERSECT and EXCEPT
- Optimization and broader support of outer joins
- Optimization of partitioned tables
- Optimization of criteria in multi-level parent hierarchies
- Optimization of multiple predicates using MDK composite
indexes
- Optimization of criteria using primary keys
- Optimization of criteria using ASK keys
- Optimization of joins by deferring bitmap joins when appropriate
- Optimization of distinct parents by domain children
- Optimization of multiple predicates within a single Omnidex
group
- Optimization using sorted Multifinds
- Optimization of aggregations, criteria and grouping using
expressions
- Optimization of sorts using binary/merge algorithms
- Optimization of some SELECT INTO, INSERT, UPDATE and DELETE
scenarios
- Optimization of joins to use Multifind against distributed
indexes
- Redesigned EXPLAIN PLAN's
Indexing Enhancements
- Redesigned installation options, with new defaults for
SQL optimization (version 4.0.00)
- Indexing using native rowids where available, using Child
Transparency (version 4.0.00)
- Wider support for bitmap operations, using Child Transparency
(version 4.0.00)
- Support for up to 4 billion rows per table or partition
(version 4.0.00)
- Support for larger environments, using expanded Omnidex
rootfile (introduced in 3.7.50)
- Increased limit of parents installed per database from
199 to 256
- Support for >31 children per table, though only first
31 are indexed
Meta-Data Enhancements
- Automatic translation of MDK composite indexes as pseudocolumns
- Increased flexibility in declaring redefined rowids -
any datatype up to 63 bytes (version 4.0.00)
- Increased RDBMS indexing speed using required column maps
and pointers (version 4.0.00)
- Limited support for Unicode datatype
- Improved handling of orphans throughout retrieval engine
and optimizer
- Support for INDEXMAINTENANCE flag in environment catalog
to support ODXAIM
- Support for pseudocolumns in oainsertindex, oaupdateindex
and oadeleteindex to support ODXAIM
Database Enhancements
- Oracle driver rewritten to use Oracle 9i native API
- Informix driver enhanced to use fewer connections
Miscellaneous Enhancements
- Support for SORT, DISTINCT and KEYWD-class options in
oaexport and EXPORT statement
- Support for the PROXIMITY option in oafetchkeys and the
FETCHKEYS statement
- Support for QUOTES = in TDF files
- Support for DELETE option on DETACH statement
- Support for $OMNIDEX table, $COMMAND table and COMMAND
statement
- Improved syntax in the QUALIFY statement
- Improved support for OMNIDEX DATETIME datatype
- Removed requirement to re-enable bitmap operations after
a reinstallation of indexes
- Licensing for maximum number of concurrent users and maximum
number of rows per table
Omnidex Utility Enhancements
OAHELPER
- Support for MIGRATE command
- For TurboIMAGE/XL, convert '
(apostrophe) to _
(underscore), just as we do with
- (dash)
- Support for DATABASE SUBTYPES
ODXSQL
- PARTITION command
- UPDATE STATISTICS command
- Improved BENCHMARK command
- Subprocess support
- EXTRACT with FORMAT=ORACLE, CLUSTERED options
- CALC command
- IS command
- SET commands
- RESET TIMER
- <SAVE | RESTORE> SETTINGS
- SAVE HISTORY
- USE with SILENT
- Commands for dumping summaries and contents of all caches
- Commands for dumping all open files and their owner within
source
- Commands for dumping all memory usage by owner within
source
- VERSIONS (and oaversion routine)
Removed Features
- Support for PRECEDENCE settings and options governing
Boolean order of precedence
- Support for multiple versions of structures in info routines
Obsolete Features
Operating Systems | Database
Platforms| Omnidex Programs| OmniAccess
Routines| Datatypes
Operating Systems
Database Platforms
- Oracle 6.x/7.x
- Informix 5.x/6.x
- Sybase
- ISAM/C-ISAM
- TurboIMAGE/XL
- RMS Files
Omnidex Programs
OmniAccess Routines
- oadroptable
- oalist
- oaform
- oashow
- oacopyfile
- oaconvertdata
Datatypes
- Boolean
- Bitmap
- HP Float
- D Float
- F Float
- G Float
- Left Overpunch Zoned
- Right Separate Zoned
- Left Separate Zoned
- Right ASCII Overpunch Zoned
- Left ASCII Overpunch Zoned
- Radix 50
- RSI Date
- VMS Datetime
- Sybase Datetime
- RMS Rowid
- Image Rowid
- Sybase Rowid
- ISAM Rowid
- CISAM Rowid
- DISAM Rowid
top
|
|