Re: Optimization via explicit JOINs

Actually, just thought of something else. If you remove
the probably redundant p.song_id=s.song_id from the second
query (since the join ... using should do that) does it
change the explain output?

On Fri, 9 Mar 2001, David Olbersen wrote:

> On Fri, 9 Mar 2001, Stephan Szabo wrote:
>
> ->As a question, how many rows does
> ->select * from playlist p join songs s using (song_id) where
> ->p.waiting=TRUE;
> ->actually result in?
>
> Well it depends. Most of the time that playlist table is "empty" (no rows where
> waiting = TRUE), however users can (in a round about way) insert into that
> table, so that there could be anywhere from 10, to 2,342, to more.
>
> Why do you ask?
>
> (The reason those plans chose 14 was because, at the time, there were 14 rows in
> playlist)