Re: different SQL approaches

>
> 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? Received on Mon Oct 18 2004 - 10:29:00 CDT