null or value
- From: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Sep 2009 14:43:04 -0400
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
Thanks
Randy
Other related posts:
