Re: Optimization via explicit JOINs

Поиск
Список
Период
Сортировка
От David Olbersen
Тема Re: Optimization via explicit JOINs
Дата
Msg-id Pine.LNX.4.31.0103091445480.5872-100000@bubbles.electricutopia.net
обсуждение исходный текст
Ответ на Re: Optimization via explicit JOINs  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Optimization via explicit JOINs  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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).

-- Dave



В списке pgsql-sql по дате отправления:

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