When you configure the index feature, you can set fields to the numeric type and query key values by number range.

Description

Supported types: long (long integers) and double (decimals). If you set a field to a numeric type, only values within a number range can be used to query the key value.

Query data

To query the key value of longkey whose range is (1000 2000], use the following methods:

  • Query by specifying the numbers. Example:

      longKey > 1000 and longKey <= 2000
  • Query by specifying the number range. Example:

      longKey in (1000 2000]

For more information about syntax, see Query syntax.