Subject | Re: Re[2]: [Firebird-Architect] Index structures |
---|---|
Author | Jim Starkey |
Post date | 2003-06-07T00:15:27Z |
At 01:56 AM 6/7/2003 +0200, Arno Brinkman wrote:
Jim Starkey
>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% !
Jim Starkey