[Firebird-devel] [FB-Tracker] Created: (CORE-3889) Please add support for -? in firebird.exe
Please add support for -? in firebird.exe - Key: CORE-3889 URL: http://tracker.firebirdsql.org/browse/CORE-3889 Project: Firebird Core Issue Type: Improvement Affects Versions: 3.0 Alpha 1 Reporter: Carlos H. Cantu Priority: Minor Please enhance firebird.exe to support the -? command line switch and return all the supported switches. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- 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
Re: [Firebird-devel] Evaluation of derived tables and CTE's
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, a full table scan is still required to calculate COS(ColumnB) and then compare it against ColumnA, no amount of indices is going to help against that. I am not really sure if Firebird will actually able to use indices for evaluating ColumnA = ColumnB either, but I assume that will only work if both columns have an index. Mark -- Mark Rotteveel -- 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
Re: [Firebird-devel] Evaluation of derived tables and CTE's
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
Re: [Firebird-devel] Evaluation of derived tables and CTE's - Email found in subject
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