> -----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? C. ------------------------------------------------------------------------------ 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
