Re: Indexes with few values

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

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

If you are using Oracle7.3 and the index is bitmapped one, it will help you great;
otherwise, normal index will do no help to you.  

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049