Subject Re: Re[2]: [Firebird-Architect] Index structures
Author Jim Starkey
At 01:56 AM 6/7/2003 +0200, Arno Brinkman wrote:

>It is not possible with the current index-structure.
>So my idea is for unique-index-key-lengths <= 8 (or user can force to use
>them) to store the full key in the index. This way we can do faster
>inserts/deletes/searches. I've already implemented in my local tree to see
>how much (or not) performance it would bring. The speed-win on queries
>(ofcourse where the index is used) is about 30-50% and the index-pages grow
>by 50% !


Doesn't sound right. Let's see your raw data.

Jim Starkey