This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
oaenv:home [2009/12/18 16:43] admin |
oaenv:home [2009/12/18 16:44] admin |
||
---|---|---|---|
Line 389: | Line 389: | ||
DOUBLE Double-precision floating point data stored in 8 bytes. This is equivalent to a “datatype FLOAT length 8”. | DOUBLE Double-precision floating point data stored in 8 bytes. This is equivalent to a “datatype FLOAT length 8”. | ||
+ | |||
<code> | <code> | ||
Figure 2 - Examples of Declaring Datatypes Using New and Existing Syntax | Figure 2 - Examples of Declaring Datatypes Using New and Existing Syntax | ||
Line 447: | Line 448: | ||
OMNIDEX BLOB 1999 bytes bytes + 4 | OMNIDEX BLOB 1999 bytes bytes + 4 | ||
</code> | </code> | ||
+ | |||
==== LENGTH n ==== | ==== LENGTH n ==== | ||
Line 532: | Line 534: | ||
The cardinality of a column is the number of distinct values in the column. This number should be near the actual column cardinality. Omnidex uses this number to better optimize some queries. | The cardinality of a column is the number of distinct values in the column. This number should be near the actual column cardinality. Omnidex uses this number to better optimize some queries. | ||
+ | |||
===== $RETRIEVE_FILE ===== | ===== $RETRIEVE_FILE ===== | ||
+ | |||
<code> | <code> | ||
$RETRIEVE_FILE(filename [,’datatype’ [,length [,’options’]]]) | $RETRIEVE_FILE(filename [,’datatype’ [,length [,’options’]]]) |