Subject Re: SV: [Firebird-Architect] Indexes for big objects
Author Nando Dessena
Pavel,

P> Sorry, still can't see why it would be good to have it built in the
P> system, when you can solve that easily at "application" level, i.e. use
P> hashes and queries like:

apart from what Andrew Berg wrote, which I find entirely appropriate, I
have to underline that you cannot reliably enforce uniqueness
at the application level in a multi-user scenario, unless things
changed while I wasn't watching.

P> What many people would really want is quick search for value parts in
P> long values (STARTING WITH, CONTAINING)

Sure, but this is a completely different matter. I'd like to have
stored functions, by the way, but doesn't mean I can't see the value
in indexing large objects. ;-)

Ciao
--
Nando Dessena