Re: About indexes

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Mon, 17 Oct 2005 19:27:32 +0000 (UTC)
Message-ID: <dj0tv4$fd8$1@nntp.init7.net>

On 2005-10-17, daniellopez21 <daniellopez21_at_gmail.com> wrote:
> Hello,
>
> I have a table with 3.000.000 rows. The column 'A', have 2 posssible
> values: RE or FI.
>
> The value RE is in 2.950.000 rows, and the value FI is in 50.000 rows.
>
> i want execute : DELETE FROM my_table WHERE my_column = 'FI'.
>
>
> ¿¿ I should create index in my_column ??? Bitmap index??
>
>
> I'm sorry, but my english is disastrous.

I wouldn't create an index just to delete the rows. But it _could_ make sense if you're going to delete FI-rows more than once.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Mon Oct 17 2005 - 14:27:32 CDT