Views and query planner
От
Mario Splivalo
Тема
Views and query planner
Дата
Msg-id
1151670948.27032.5.camel@localhost.localdomain
Список
Дерево обсуждения
Views and query planner Mario Splivalo <mario.splivalo@mobart.hr>
Re: Views and query planner Michael Glaesemann <grzm@seespotcode.net>
Re: Views and query planner Mario Splivalo <mario.splivalo@mobart.hr>
Re: Views and query planner Markus Schaber <schabi@logix-tt.com>
Let's say I have a view like this: CREATE VIEW v_small AS SELECT c1, c2 FROM t1 JOIN t2 ON t1.c1 = t2.c2 and then I have another view CREATE VIEW v_big AS SELECT c1 FROM v_small WHERE c2 > 5 Now, when I do this: SELECT * FROM v_big WHERE c1 < 1500 Is postgres going to make one query plan, or each view has it own query plan? Mike -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."
В списке pgsql-sql по дате отправления