Hi, Subqueries uses indexes i "the same way" as primary query.
Show us this subquery and query plan returned by server. Will be good to see also Firebird version 1.5, 2.1, 2.5? Regards, Karol Bieniaszewski ----- Reply message ----- Od: "hosodaamiya" <[email protected]> Do: <[email protected]> Temat: [firebird-support] Indexes on subquery Data: pt., lis 29, 2013 04:00 Hi all, Is it the designed behavior that indexes are not used in subquery? If it is desined at present, the function for index in subquery will be implemented in versions of the future? Regards, Shingo
