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 по дате отправления
От: Jason Farmer
Дата:
От: Michael Glaesemann
Дата:
Сообщение: Re: Views and query planner
FAQ