|
<< Click to Display Table of Contents >> Index support: what is possible and what not ? |
  
|
Index support: what is possible and what not ?
|
<< Click to Display Table of Contents >> Index support: what is possible and what not ? |
|
What is currently supported ?
The following syntax of the INDEX ON command (and functions) is supported
INDEX ON <uKeyValue> [TAG <xcOrder>] [TO <xcIndexFile>]
[UNIQUE] [ASCENDING | DESCENDING] [ADDITIVE]
What is NOT supported ?
The following elements of the INDEX ON command are NOT supported
[WHILE <lCondition>]
[FOR <lCondition>]
[EVAL <cbEval> [EVERY <nInterval>]
[USECURRENT] [CUSTOM] [NOOPTIMIZE]
Unique Indexes
The VO2ADO RDD handles the UNIQUE property of an index differently than the standard RDDs. It tries to create an Unique Index on the server, which will fail if two rows in the table have the same index key value(s).