RE: How to calculate cardinality for inequality in WHERE

From: <Christopher.Taylor2_at_parallon.net>
Date: Thu, 11 Jul 2013 10:44:04 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A2BB21BA_at_NADCWPMSGCMS10.hca.corpad.net>

This is a really interesting discussion and I'm curious if you can use a CASE instead of DECODE in the virtual column you created? (DECODE seems more expensive than CASE if I remember correctly in normal SQL) Chris

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham Sent: Thursday, July 11, 2013 10:37 AM
To: IIotzov_at_newsamerica.com; Martin.Klier_at_klug-is.de; oracle-l_at_freelists.org Subject: RE: How to calculate cardinality for inequality in WHERE

Iotzov: That is a slick idea.

Martin: If it were worthwhile in your situation to be extremely fast at finding just the relevant rows, then:

alter table junk23 add (id1_lt_id2 number as (decode(id1-id2,-1,id1-id2,0,null,null)));
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 11 2013 - 17:44:04 CEST