On 20 Jun 2017, at 1:34am, Jens Alfke <[email protected]> wrote:
> My understanding from reading the docs is that SQLite view’s aren’t “built” > at all: their contents have no physical existence in the database, the views > are simply macros that transform the statements that use them. (Correct me if > I’m wrong; I haven’t actually used views.) You’re right. When you create a VIEW SQLite stores the CREATE VIEW command, and not the data it retrieves. When the VIEW is used in a later command SQLite integrates the two commands. > You can create indexes to support JSON1 queries by using the same json_xx > function calls in a CREATE INDEX statement. That’s a great idea. I don’t know if it works, though. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
