Use what kind index?

From: <cnwy_at_my-deja.com>
Date: 2000/08/11
Message-ID: <8n12nl$k7g$1@nnrp1.deja.com>#1/1

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 Fri Aug 11 2000 - 00:00:00 CDT