Re: Change in computation of IXSEL between 8.1.6 and 8.1.7

Are the sql and all parameters the same? Can you post/send the full 10053 traces.
I worked with version 8.1.6 only very briefly and many many years ago.

At 02:33 PM 9/19/2004, jaromir nemec wrote:
>Hello List,
>In 8.1.6.3.0, 64 bit (HP-UX) gives the predicate
>
>ca.column1 = '40' and ca.column2 like '5.13341%'
>
>an IXSEL of 5.8878e-07 (corresponding exactly to density of the column2).
>See extracts of 10053 event trace:
>
>In 8.1.7.4.0 - 64bit gives the same predicate IXSEL of only 9.0000e-03 (4
>order of magnitude difference). The data is not exactly the same, but this
>cannot explain this big difference.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l