Query Processor Support

The query processor uses a virtually hashed index only if you include search arguments that include an equality qualifier (for example, where id=2) on all key columns.

If the query processor uses the virtually hashed index, it includes a line similar to this in the showplan output:

Using Virtually Hashed Index.

The query processor includes lines similar to this in the index selection output if it selects a virtually hashed index:

Unique virtually hashed index found, returns 1 row, 1 pages