Show pagesource
Old revisions

This is an old revision of the document!

© DISC

Omnidex SQL Overview Statements Functions Examples Quick Ref
OdxSQL Overview Commands Settings Command Line Quick Ref
Programs OdxSQL OdxNet OdxAim versions
Legacy Progs. oacomp dbinstal oahelper oadecomp Leg. Env. Syntax
Data Stores Raw data files Oracle SQLServer MySQL ODBC
Datatypes Omnidex Oracle SQLServer MySQL ODBC
DDL Create Create Env. Create Database Create Table Create Index Create Index Group
DDL Drop Drop Env. Drop Datebase Drop Table Drop Index Drop Index Group
SQL DML Select Insert Delete Update Qualify
SQL Access Connect * Disconnect * Attach Detach Set
SQL Syncing Update Indexes Update Text Update Statistics Update Rollups Update Rollup Table
SQL Special Export Partition Join Open Cursor Close Cursor
SQL Other Install Indexes Remove Indexes Load OFX Command Extract *
SQL Functions Standard Extended Oracle
Special Env Variables Glossary Debugging Conn Strings Release Notes
Interfaces ODBC JDBC Oracle Stored Procs SQL Stored Procs.
Languages Java C# PHP C++
Features Snapshots Grids Rollup Tables Geo Searches
Indexing Concepts Options Strategies Updates Explain Plans
Indexing ActiveCounts PowerSearch AutoComplete Omnidex Text Adv. Strategies
————————–————————–——————————–——————————–——————————–——————————–

* Statement is only available from OdxSQL.

Omnidex SQL Index Query Statements

Omnidex supports lower level QUALIFY and JOIN statements to query the Omnidex indexes directly. These statements are advanced statements used for testing and to support legacy applications. The SELECT statement is now typically used instead.

QUALIFY Qualify index counts using Omnidex criteria.
JOIN Join tables using Omnidex Indexes.
Overview Topics Administration Development General
What is Omnidex? Fast Counts Omnidex Administrator Omnidex SQL Reference Software Installation
Omnidex Architecture Fast Aggregations OdxSQL ODBC Platform Support
Omnidex on Customer Lists Textual Searches Optimizing Query Performance JDBC Release Notes
Omnidex on Business Analytics Fuzzy Searches RDBMS Topics Stored Procedures Glossary
Omnidex on Transaction Logs Portable Snapshots Legacy Tools/APIs Debugging Documentation Map
Omnidex on Flat File Databases Scalable Grids Administrator FAQ Developer FAQ Installation FAQ

(c)Copyright Dynamic Information Systems - This document was last updated March 30, 2011

 
Back to top
quicklinks.1303000529.txt.gz · Last modified: 2012/10/26 14:39 (external edit)
Sitemap Recent Changes