Re: How to calculate cardinality for inequality in WHERE

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

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