> If I am querying data just from t1, is there a performance penalty for using > myview in the query? Or will the query planner generate approximately the > same bytecode as it would if I'd simply queried t1?
Yes, there is performance penalty and no it can't generate the same bytecode. If you ask why the answer is because result set from the view can be different than from the table alone - several rows in the view can contain information from the same row of t1. Pavel On Fri, Mar 2, 2012 at 11:23 AM, Duquette, William H (318K) <william.h.duque...@jpl.nasa.gov> wrote: > Howdy! > > Suppose I have two related tables, t1 and t2, and I write a view like this: > > CREATE VIEW myview AS SELECT * FROM t1 JOIN t2 USING (some_column); > > If I am querying data just from t1, is there a performance penalty for using > myview in the query? Or will the query planner generate approximately the > same bytecode as it would if I'd simply queried t1? > > > -- > Will Duquette -- william.h.duque...@jpl.nasa.gov > Athena Development Lead -- Jet Propulsion Laboratory > "It's amazing what you can do with the right tools." > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
