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)
Список
Дерево обсуждения
Optimization via explicit JOINs David Olbersen <dave@slickness.org>
Re: Optimization via explicit JOINs Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Optimization via explicit JOINs David Olbersen <dave@slickness.org>
Re: Optimization via explicit JOINs Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Optimization via explicit JOINs David Olbersen <dave@slickness.org>
Re: Optimization via explicit JOINs Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Optimization via explicit JOINs David Olbersen <dave@slickness.org>
Re: Optimization via explicit JOINs Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Optimization via explicit JOINs Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Optimization via explicit JOINs Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления