null or value
From: Steiner, Randy <Randy.Steiner_at_nyct.com>
Date: Wed, 16 Sep 2009 14:43:04 -0400
Message-ID: <D5006AF7251D5046A0A63E39A23148DC020FD828_at_NYCTEXVS07.transit.nyct.com>
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?
Date: Wed, 16 Sep 2009 14:43:04 -0400
Message-ID: <D5006AF7251D5046A0A63E39A23148DC020FD828_at_NYCTEXVS07.transit.nyct.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 16 2009 - 13:43:04 CDT