Index a View in SQLite

Question

Good afternoon,

Is there any way I can build an index for a view in SQLite?

Thank you very much.

Answer 1

Accessing a view will use the indexes defined on the underlying tables in the view, if those indexes meet the selection and filtering criteria.

So, even though you cannot define an index on a SQlite view, table indexes may still be appropriate.

Answer 2

This thread from a frequent online SQLite commenter says no:

>Hi
>
>May I know if we can create index on a View?

You can't create an index on a VIEW.
A VIEW can be seen as a stored SELECT statement. 

>Thanks in advance.
>wying
-- 
( Kees Nuyt
)