Subject | RE: [Firebird-Architect] Indexes for big objects |
---|---|
Author | Leyne, Sean |
Post date | 2006-07-07T20:58:41Z |
Ann,
uniqueness.
By even then, now with an index that can be up to 4096 bytes in size,
how realistic is it need an even larger key?
Maybe I'm looking at this to narrowly... can you give an example that
might help me 'see the light'?
Sean
> The index itself would be a standard btree using the hashI don't see the value of this type of index, expect to handle
> as the value. It would be useless for returning records
> in sorted order - but good for retrieval and unique
> constraints. From the application perspective, there would
> be no difference in definition - just removing the limit on
> the length of the key.
>
> Thoughts?
uniqueness.
By even then, now with an index that can be up to 4096 bytes in size,
how realistic is it need an even larger key?
Maybe I'm looking at this to narrowly... can you give an example that
might help me 'see the light'?
Sean