13.07.2012 0: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
If ColumnA and ColumnB belong to the same table, neither will use an index. If they're from different tables and you join them, both will use an index for ColumnA. Dmitry ------------------------------------------------------------------------------ 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
