AK wrote:
>>While your example is correct if you think the solution is to use string
>>literals rather than histograms I would suggest you are using a hammer
>>as a screw driver.
>
>
> Daniel,
>
> I think having up-to-date histograms for columns with data skew is
> essential in Oracle 9i environment. CBO uses the histograms to choose
> the most appropriate plan for each value.
>
> Do you know a better approach?
I thought that was exactly what I was suggesting. ;-)
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Oct 18 2004 - 22:43:23 CDT
