Hi All,
I have been reading about set returning functions. What I would like to
know is is there a performance advantage in using SRFs versus querying a
view. Assuming the underlying SQL is the same for the view vs the
function except for the WHERE clause which of these would you expect to
be faster? Or does the planner realize all this...
SELECT * FROM view_big_query WHERE column1 = 1234;
SELECT * FROM func_bug_query(1234);
--
Kind Regards,
Keith