> On Fri, 9 Mar 2001, Stephan Szabo wrote:
>
> ->Not entirely. Those are only estimates, so they don't entirely line up
> ->with reality. Also, I notice the first estimates 14 rows and the second
> ->1, which is probably why the estimate is higher. In practice it probably
> ->won't be significantly different.
>
> So really I'm just getting back estimations of cost and rows returned?
> Incidentally, both queries returned the same data set, that's a Good Thing (tm).
Yeah, explain is mostly ofr showing what it's going to do and a little bit
of why it thinks it's a good idea. Hmm, what were the two queries anyway?
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
