|Subject||Re: Re: [Firebird-Architect] Index structures|
At 01:56 AM 6/7/2003 +0200, Arno Brinkman wrote:
>It is not possible with the current index-structure.Doesn't sound right. Let's see your raw data.
>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% !