Support Inverted Index on Single Numerical Column

[Lloyd-Pottiger]

Feature Request

Inverted Index is a commonly used indexing technique in the field of information retrieval. It divides text into individual words and constructs a word -> document IDs index, allowing for quick searches to determine which documents contain a specific word.

For a single numerical column, we can simplify store a mapping from number to its locations in a column (value  → rowid). Thus, using an inverted index, you can quickly locate rows containing specific values, thereby accelerating the WHERE clause.