Re: Optimization via explicit JOINs
От | Stephan Szabo |
---|---|
Тема | Re: Optimization via explicit JOINs |
Дата | |
Msg-id | Pine.BSF.4.21.0103091508360.82223-100000@megazone23.bigpanda.com обсуждение исходный текст |
Ответ на | Re: Optimization via explicit JOINs (David Olbersen <dave@slickness.org>) |
Ответы |
Re: Optimization via explicit JOINs
|
Список | pgsql-sql |
> 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?
В списке pgsql-sql по дате отправления: