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: Assessment question on indexes

Re: Assessment question on indexes

From: Anurag Varma <avoracle_at_gmail.com>
Date: 10 Feb 2005 10:13:21 -0800
Message-ID: <1108059201.199793.195040@z14g2000cwz.googlegroups.com> 






Take for example:


If somehow the product_id and warehouse_id are nullable columns .. then
there is no way oracle will use


the index since null keys will not be stored in the index.



The thing Richard points out that more information is required *before*
an answer can be given. Its supposed


to be an OCP .. not a game of poker.
Received on Thu Feb 10 2005 - 12:13:21 CST












Original text of this message













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