Subject Index types
Author Elifarley C. Coelho
I think it would be nice if we could choose the index structure in CREATE
INDEX statements, like whether it should be a sorted, hashed, or B+ tree
based index, whether it should be clustered or unclustered, sparse or

We could get some performance improvement by fine-tuning these settings, I
suppose. (A hashed index would perform better than a sorted index in a table
with frequent updates, for instance)

BTW, what's the default index structure in IB6?


Elifarley C. Coelho
Belo Horizonte - Brazil

Ib-architect mailing list