What's new in the virtual table interface, Version 12.10

Access methods that are created through the virtual table interface now process IN conditions in query predicates that operate on simple columns. Processing through a virtual table interface is generally faster than SQL processing. For example, queries with IN conditions that you run on time series virtual tables now run faster than in previous releases.

You can create an access method through the virtual table interface to process qualifiers to a WHERE clause that contain multiple column, constant, or expression parameters. Processing through a virtual table interface is generally faster than SQL processing. Previously, the virtual table interface processed only simple qualifiers that consisted of a Boolean operator that compared a column name and a constant. You can use the new parameter descriptor to describe multiple column, constant, or expression parameters to the qualifier clause.