Re: Use what kind index?

We were in same situation almost.
our cilent was using bitmap indexes on a column which gets updated but not that much. and it was OK very fast.
In your case update insert,delete would be abit slower but when you are having that many records then it worth it.

then our clint changed their licence from EE to standard edition and since bitmap is only supported in EE, we had to remove them all. by useing hints and .. we got almost the same respond time. Tom
<cnwy_at_my-deja.com> wrote in message news:8n12nl$k7g$1_at_nnrp1.deja.com...
> I have a table about 1,100,000 records.
> Create Table Card
> (No char(10),
> Client char(15),
> ...
> Status(1),
> )
> Status in ('1','2','3','4','5')
> the status of each card change from '1' to '5'
> the status of new card is '1',the finished status is '5'
> after system runs for a long time,
> '1' 3%
> '2' 5%
> '3' 5%
> '4' 10%
> '5' 77%
> we always do the query with status '4' and '1'
>
> How should I create indexes on the table(normal indexes or bitmap
> indexes)?
>
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Aug 15 2000 - 03:49:52 CDT