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: NULL or 0 for a "FLAG_COLUMN"

Re: NULL or 0 for a "FLAG_COLUMN"

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Sep 2006 22:22:18 -0700
Message-ID: <1157606535.121473@bubbleator.drizzle.com> 





IANAL_VISTA wrote:



> You should also keep in mind that NULLs can never be indexed; which could 

> lead to performance issues.




Sometimes with performance advantages if you have skewed data: Many
NULLs ... fewer values.

-- 
Puget Sound Oracle Users Group


Received on Thu Sep 07 2006 - 00:22:18 CDT












Original text of this message













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