The query processor uses a virtually-hashed index only if
you include search arguements that include a 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
