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
dense...

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?


Regards,

Elifarley C. Coelho
Belo Horizonte - Brazil

_______________________________________________
Ib-architect mailing list
Ib-architect@...
http://mers.com/mailman/listinfo/ib-architect