Re: Index Cost Calculation Mystery
From: Martin Klier <usn_at_usn-it.de>
Date: Wed, 26 Jun 2013 22:45:07 +0200
Message-ID: <51CB52D3.8070605_at_usn-it.de>
Hi Sayan,
Date: Wed, 26 Jun 2013 22:45:07 +0200
Message-ID: <51CB52D3.8070605_at_usn-it.de>
Hi Sayan,
but how comes? The first column is the same in both indexes, and the second column of IDX2_AUFTRAG (dategAuftragsNr) is not in the where condition...
Thanks
Martin
Sayan Malakshinov schrieb:
> Martin,
>
> look at selectivity:
> 0.000034 - for IDX2_AUFTRAG
> 0.000241 - IDX7_AUFTRAG
>
> By all I know IDX7_AUFTRAG should be the better choice. How can I find
> out why cost is calculated this way?
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 26 2013 - 22:45:07 CEST