----- Original Message ----- From: "Claudio Valderrama C." <cva...@usa.net> To: "'For discussion among Firebird Developers'" <firebird-devel@lists.sourceforge.net> Sent: Tuesday, November 29, 2011 11:00 AM Subject: Re: [Firebird-devel] Created: (CORE-3672) computed indexbysubstring function for long columns
>> -----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 ------------------------------------------------------------------------------ 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