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: dave mausner <dmausner_at_ameritech.x.net>
Date: Fri, 07 Jan 2000 03:54:27 GMT
Message-ID: <8EB3DF9D3dlm@206.141.192.241> 





mbriganti_at_my-deja.com wrote in <852sda$bci$1_at_nnrp1.deja.com>:



>Here is an interesting situation for anyone who cares.  Why does Oracle


>index nulls in the leading part of a composite index when it can never


>use them?





how did you prove that the index contained an entry with a null leading 
edge?



-- 


dave mausner
Received on Thu Jan 06 2000 - 21:54:27 CST












Original text of this message













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