Index
From: Ken Friday <ken_friday_at_pleasantco.com>
Date: 1996/11/15
Message-ID: <328CC692.5EF6_at_pleasantco.com>#1/1
Date: 1996/11/15
Message-ID: <328CC692.5EF6_at_pleasantco.com>#1/1
Mats Larsson wrote:
>
> 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 ?
>
>Yes an index would help assuming the SQL statement was written to take advantage.
Received on Fri Nov 15 1996 - 00:00:00 CET