Neil Conway wrote:
> Another idea would be to improve the quality of the plan we generate at PREPARE time:
> for instance you could generate 'n' plans for various combinations of
> input parameters, and then choose the best query plan at EXECUTE time.
> It's a difficult problem to solve, however (consider multiple parameters
> to PREPARE, for example).
Do you mean store different plans for each different histogram segment ?
Regards
Gaetano Mendola