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