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  (David Olbersen <dave@slickness.org>)
Список 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 по дате отправления:

Предыдущее
От: David Olbersen
Дата:
Сообщение: Re: Optimization via explicit JOINs
Следующее
От: David Olbersen
Дата:
Сообщение: Re: Optimization via explicit JOINs