Re: How to calculate cardinality for inequality in WHERE
- From: Martin Klier <usn@xxxxxxxxx>
- To: Martin.Klier@xxxxxxxxxx
- Date: Tue, 16 Jul 2013 13:54:10 +0200
Hi listers,
thanks to all of you who spent time and effort in this issue. For all of
you who are interested in details, here comes a blog entry about the it,
and how to reproduce easily. It's partially meant as a "lesson learned"
for developers, too.
http://www.usn-it.de/index.php/2013/07/16/oracle-sql-optimizing-a-where-predicate-inequality-with-a-function-based-index/
Best regards
Martin
Martin Klier schrieb:
> Hello listers,
>
> today again, a question merely for understanding than for solving a
> current problem.
>
> DB-Version 11.2.0.3.6 SE on Linux x86_64
>
> select * from TABLE
> where QTY1 < QTY2;
>
> There are approx. 1.5 million rows in this table.
> QTY1 < QTY2 means 0, 1 or 2 rows at max
--
Usn's IT Blog for Oracle and Linux
http://www.usn-it.de
--
//www.freelists.org/webpage/oracle-l
Other related posts:
