I wouldn't mind being able to provide hints to the planner. For
example, I have some set-returning functions that typically return
10-100 rows and I usually have a good idea of how many rows a
particular set of inputs will generate, and sometimes I know other
characteristics about those rows as we
On Sat, Mar 05, 2005 at 11:05:32AM -0500, [EMAIL PROTECTED] wrote:
> Being able to assign "hints" to queries may be able to allow DBAs to tune
> queries in tables who's characteristics are misrepresented by the
> statistics in ANALYZE.
I wouldn't mind being able to provide hints to the planner.
Tom recently said, when talking about allowing the user (in this case me)
from passing a hash table size to "create index:"
"but that doesn't mean I want to make the user deal with it."
I started thinking about this and, maybe I'm old fashioned, but I would
like the ability to deal with it. So m