Create Small Indexes Using BINTOC( ) Sample
File: ...\Samples\Solution\Db\Index1.scx
This sample shows various indexing schemes you can use with numeric and integer data types to get significant savings in index size and disk space consumed. In addition, smaller sized indexes usually result in faster searches. The BINTOC() function makes it possible for you to convert an integer (numeric) value to a binary character representation.
Syntax
BINTOC(nExpression [, nSize])
Depending on the size of your expression, you can set the nSize parameter to accommodate the value of your expression in the least amount of characters.
The following line of code creates an index on a numeric field:
INDEX on line_no TAG line_no
The next time you are working with indexes on numeric integer data, consider using something like the following:
INDEX on BINTOC(line_no,1) TAG line_no