Mark, > On 12-7-2012 22:14, Leyne, Sean wrote: > > Bad example, I should have said that: > > > > SELECT ... FROM ... WHERE ColumnA = COS( ColumnB) > > > > Doesn't use an index when it should be able to, just as the engine is > > able to use an index for this query > > > > SELECT ... FROM ... WHERE ColumnA = ColumnB > > It is still a bad example
@#$@#%$#$%@#$% You are right. I know that I have seen the problem, but can't for the life of me find the example at the moment. Let's leave this die, sorry for the wasted bandwidth. Sean ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
