Re: To index or not to index....

Hi,

I think the the columns should not be indexed, because,
The selectivity on the columns is bad. It is expected, as I assume , to have only two values 'Y' or 'N'. You could create a bitmap index on it but I assume the columns will updated often. So that option too is out.

Johnson

• Mary Laxton <marylaxton_at_hotmail.com> wrote:
  > Hello everyone,
  >
  > I have status_ind and finialized_ind columns on most
  > of my tables.
  > Currently, these columns are not indexed, which is
  > not a good thing. The
  > status_ind indicates whether or not the record is
  > the current record or the
  > logically deleted record(s). The finialized_ind
  > column is also used in a
  > similiar fashion.
  >
  > Most of these tables have indexes on other columns
  > for specific reasons.
  > But for some reason the previous DBA chose not to
  > index these columns.
  >
  > So I am trying to figure out if there is some sort
  > of rule about how many
  > indexes a table can have before it has too many
  > indexes??
  >
  > Thanks a bunch!!
  >
  > Mary
  >
  

  ---

  
  > Get Your Private, Free E-mail from MSN Hotmail at
  > http://www.hotmail.com.
  >
  > Share information about yourself, create your own
  > public profile at
  > http://profiles.msn.com.
  >
  >
  > --------
  > Think you know someone who can answer the above
  > question? Forward it to them!
  > to unsubscribe, send a blank email to
  > oracledba-unsubscribe_at_LAZYDBA.com
  > to subscribe send a blank email to
  > oracledba-subscribe_at_LAZYDBA.com
  >
  

  ---