Re: Index Cost Calculation Mystery
- From: Martin Klier <usn@xxxxxxxxx>
- To: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- Date: Wed, 26 Jun 2013 22:45:07 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
