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
Indexing ActiveCounts PowerSearch AutoComplete Omnidex Text Adv. Strategies
————————–————————–——————————–——————————–——————————–——————————–

* Statement is only available from OdxSQL.

SQL Statements by Category

Omnidex SQL Query and Export Statements

SELECT Peform a Query Specification and SELECT rows.
EXPORT Export rows or rowids to an external file.
OPEN CURSOR Open a Cursor.
CLOSE CURSOR Close a previously opened cursor.

Omnidex SQL Index and Processing Maintenance Statements

Omnidex supports several statements to synchronize the Omnidex indexes, rollup tables and internal statistics.

UPDATE INDEXES Update Omnidex Indexes.
UPDATE ROLLUP Update Rollup Table with summarized information.
UPDATE ROLLUPS Update all Rollup Tables for an Omnidex Database.
UPDATE STATISTICS Update Statistics Information.
UPDATE TEXT Update Textual Statistics.
PARTITION Partition a table into smaller sub tables based on criteria.
LOAD OFX Load Indexes for a table.
INSTALL INDEXES Specifies the Omnidex indexes into the Omnidex XML Environment. No indexing is performed.
REMOVE INDEXES Removes the Omnidex indexes from the Omnidex XML Environment.

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.1303000126.txt.gz · Last modified: 2012/10/26 14:39 (external edit)
Sitemap Recent Changes