At 22:14 26/09/2003 +0000, you wrote:

>sorry you mixed up again some things:
>
>bitmap indexes (yes oracle has them, but only the enterprise
>edition!!) are good for HIGH selectivity (e.g. table with 1 000 000
>records and you often select a few 100 000 records! low selectivity
>means that you search/select only a few records maybe 100 or 200. and
>for this LOW selectivity you normally use b-trees or b*-trees (if i
>am right firebird knows only b-trees).

Hi Alex,


I don't think so....

Index with High Selectivity means few records... low selectivity means a
lot of records...
Of course Helen have a better didactic and a better english to explain
that... see her post...

AFAIK FB has a B*-Tree variant...


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 01/09/2003


[Non-text portions of this message have been removed]