Forum: Building VoltDB Applications

Post: Indexed views?

Indexed views?
DennisP
May 10, 2013
Is it possible to create indexes on views?

At the moment I'm getting an "Unsupported internal operation: createIndex" error when compiling my DDL which tries to create an index on a VIEW so I'm guessing this is not possible but perhaps I'm doing something wrong?
DennisP
May 10, 2013
Also, the reason I want/need this is to avoid a sequential scan on the view. The original table has a tree index on a field (month_key) which avoids a sequential scan when looking up a number of rows (month_key >= 6 AND month_key <=12) and I would like to have the exact same index on my view.