>> -----Original Message-----
>> From: Vlad Khorsun [mailto:hv...@users.sourceforge.net]
>> Sent: Martes, 29 de Noviembre de 2011 5:36
>>
>> While i agree with you about SUBSTRING, i think the much
>> better solution
>> will be to allow to index COMPUTED BY columns. It allows to
>> not compare
>> potentially complex expressions at optimize time and to not
>> write exactly
>> same expressions in every query where such index is required.
>
> Then the index has to be updated each time any field involved in the
> expression changes?
There is no difference between index on computed field and expression
index in this regards. Index is updated only if new key is different from old
key.
Regards,
Vlad
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
