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
