Introduction
Software
Installation
Concepts
and Design
Designing
Applications
Omnidex
Environments
SQL
Reference
Omnidex
API's
Utilities
Interfaces
Performance
Guide
Troubleshooting
Guide
Appendix
|
OmniAccess Optimization Enhancements
- Optimization and broader support of nested queries (nested
queries in FROM clause not yet complete)
- Optimization and broader support of set operations -
UNION, INTERSECT and EXCEPT
- Optimization and broader support of outer joins
- Optimization of EXISTS clauses
- Optimization of partitioned aggregations
- Optimization of multiple predicates using MDK composite
indexes, including partitioned qualifications
- Optimization of multiple predicates within a single Omnidex
group
- Optimization of qualifications in multi-level parent hierarchies
- Optimization using sorted Multifinds
- Optimization of criteria using primary keys
- Optimization of criteria using ASK keys
- Optimization of joins by deferring bitmap joins when appropriate
- 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 distinct parents by domain children
- Optimization of joins to use Multifind against distributed
indexes
- Optimization of joins to use DR domains thereby enabling
sorted Multfinds
- Optimization of “sawtooth” join constructs
using nested queries
- Optimization of phrases on proximity indexes
- Optimization of token-specific proximity syntax on proximity
indexes
- Optimization of literal predicates such as “1=0”
or “1=1”
OmniAccess Feature Enhancements
- Auto-registration of MDK composite indexes as pseudocolumns
- Partial support for Unicode datatype
- Required column map and use of column pointers on index
builds
- Improved handling of orphans throughout retrieval engine
and optimizer
- Support for INDEXMAINTENANCE flag in environment catalog
- Pseudocolumn support in oainsertindex, oaupdateindex and
oadeleteindex
- Oracle 9i support
- Reduced connections with Informix
- Support for SORT, DISTINCT, PROXIMITY options in oaexport
and EXPORT statement
- Support for KEYWD, KWCOUNT, KWPCOUNT options in oaexport
and EXPORT statement
- Support for the PROXIMITY option in oafetchkeys and the
FETCHKEYS statement
- Support for QUOTES = <SINGLE | DOUBLE> 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
- Licensing for maximum number of concurrent users and maximum
number of rows per table
- Proper enforcement of restrictions on calling oaqualify,
oajoin and oafetchkeys between oafetches
- Support for TABLE … AUTOFILTER clause of environment
file
- Support for TOP n SKIP n clause of SELECT statement
- Automatic registration in oaconnect of environment file
directory as current working directory
- Support for 12-word TIDMAPS to support more complex Oracle
tables
- Support for SUBSTRING on columns using OCCURS where offsets
and lengths reach into occurrences
- Support for oaexplainplan as a new OA routine
- Support for indexing of C STRING fields between 4096 and
65535 bytes
- Reporting of Omnidex Addin state in oaversion routine
and versions program
- Support for oadescribe after oafetchkeys
Omnidex Utility Enhancements
OAHELPER | ODXSQL
| VERSIONS | VIEWGEN
| DBINSTAL
OAHELPER
- Support for MIGRATE command
- For TurboIMAGE/XL, convert ‘ to _, just as we do
with –
- Support for DATABASE SUBTYPES
- Generation of 4.0 syntax installation scripts from 3.8
- Support for –sw switch (for Speedware use only)
ODXSQL
- Support for ODXSQL against the Omnidex Client using –api=ODBC
command line switch
- Redesign of EXPLAIN PLAN
- Subprocess support
- SET AUTORECONNECT <ON | OFF>
- SET HEADER <ON | OFF>
- SET PREPROCESSOR <ON | OFF>
- SET STATISTICS <ON | OFF>
- SET STATUSDISPLAY <ON | OFF>
- SET ERRORDISPLAY NONE <SAVE | RESTORE> SETTINGS
- SAVE HISTORY
- SET TIMER CUMULATIVE
- RESET TIMER
- EXTRACT with FORMAT=ORACLE, CLUSTERED options
- USE with SILENT
- OXKERNEL
- ERROR
- HELP API
- 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)
- Display of number of processors
- Display of licensing information
- Display of Omnidex Addin state
VIEWGEN
- Support for outputting to TDF or OST file
- Removal of capability to process dimensions separately
and then merge superviews
DBINSTAL
- MI command shows mapping of index files
Obsolete and Removed Features
- Support for Informix Version 5
- Support for Oracle Version 6
- Support for PRECEDENCE settings and options governing
Boolean order of precedence
- Support for multiple versions of structures in info routines
- Removal of IAKEY option of oafetchkeys (converted to internal
option)
- Removal of GNU’s Readline library
top
|
|