Folks,
I'm wondering if it might be useful to be able to add estimated selectivity to
a function definition for purposes of query estimation. Currently function
scans automatically return a flat default 1000 estimated rows. It seems
like the DBA ought to be able to ALTER FUNCTION and give it a row estimate
for planning purposes.
Thoughts?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco