Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Number 1 gripe about CBO: 0 <Cardinality< 1 (?????)

Re: Number 1 gripe about CBO: 0 <Cardinality< 1 (?????)

From: Kevin Kirkpatrick <kvnkrkptrck_at_gmail.com>
Date: 6 Apr 2007 07:49:35 -0700
Message-ID: <1175870975.812191.321390@b75g2000hsg.googlegroups.com> 





> which can be expressed as

>

> "(START_DATE IS NULL OR START_DATE < SYSDATE) AND (END_DATE IS NULL OR

> END_DATE > SYSDATE)"


>



should be:


"(START_DATE IS NULL OR START_DATE <= SYSDATE) AND (END_DATE IS NULL
OR  END_DATE >= SYSDATE)"

Received on Fri Apr 06 2007 - 09:49:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US