> What kind of JOIN is used when it a type (INNER, OUTER, etc.) is not > specified?
INNER is default. Pavel On Fri, Mar 2, 2012 at 11:37 AM, Rob Richardson <[email protected]> wrote: > What kind of JOIN is used when it a type (INNER, OUTER, etc.) is not > specified? > > RobR > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Duquette, William H > (318K) > Sent: Friday, March 02, 2012 11:23 AM > To: Discussion of SQLite Database > Subject: [sqlite] Views and Performance > > 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? > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
