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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle indexes nulls in the leading part of a composite index???

Re: Oracle indexes nulls in the leading part of a composite index???

From: Jan-Erik Rosinowski <spamfilter_at_rosinowski.de>
Date: Fri, 07 Jan 2000 11:12:21 GMT
Message-ID: <3875a6e1.4751091@News.CIS.DFN.DE>


>THIS ROW GETS INDEXED, but can Oracle ever use this entry in the
>index? Can anyone think of a WHERE clause?

...where non_mandatory_column is null and mandatory_column='ABC'

??? should be quite ok as long as the index is not unique or primary

ciao, jan

http://www.rsp.de - Software zur effizienten Erstellung und Verwaltung von Gutachten, Analysen, Pruefprotokollen etc. Received on Fri Jan 07 2000 - 05:12:21 CST

Original text of this message

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