Indexes with few values

From: Mats Larsson <matlar_at_rsv.se>
Date: 1996/11/13
Message-ID: <56bs41$pu3_at_u30039.rsv.svskt.se>#1/1


Suppose I have a table where one of the columns has only three different values :

null 1 miljon rows
'J' 1 miljon rows
'N' 0 - 100 rows.

If I want to search for rows with the value 'N' then an index would help wouldn't it ?

TIA Mats


Mats Larsson          |  Tel:   +46 8 7647921 
                      |  Fax:   +46 8 6279632
171 94 Solna, Sweden  |  Email: matlar_at_rsv.se
Received on Wed Nov 13 1996 - 00:00:00 CET

Original text of this message