null or value

From: Steiner, Randy <>
Date: Wed, 16 Sep 2009 14:43:04 -0400
Message-ID: <>

I have a table with 1 - 2 million records. I need to add a column to indicate if the records is active or not. I would guess that only 1,000 of the records would not be active. Should I make one of the values null? So I could put a Y or Null? Or put Y or N?

Would a b-tree or bitmap index do any good?  

Generally I would want to see all the records that are active  



Received on Wed Sep 16 2009 - 13:43:04 CDT

Original text of this message