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."