Re: [firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-19 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
: firebird-support@yahoogroups.com Sent: Tuesday, August 18, 2015 8:03 PM Subject: Re: [firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX  Den 18.08.2015 16:59, skrev 'Mr. John' mr_joh...@yahoo.com [firebird-support]: HI,in SP I have this query   FOR EXECUTE STA

Re: [firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-18 Thread setysvar setys...@gmail.com [firebird-support]
Den 18.08.2015 16:59, skrev 'Mr. John' mr_joh...@yahoo.com [firebird-support]: HI,in SP I have this query FOR EXECUTE STATEMENT 'SELECT SUM(CANT) FROM TABLE1 WHERE FIEL1='||:F1||' AND FIEL2='||:F2|| IIF(:pCondition=1,' AND FIEL3='||:F3,'') INTO .. DO .. TABLE1 PK =FIELD1,FIELD2,FIELD3 ru

[firebird-support] MAKE 'EXECUTE STATEMENT' USE INDEX

2015-08-18 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
HI,in SP I have this query   FOR EXECUTE STATEMENT 'SELECT SUM(CANT)  FROM TABLE1 WHERE FIEL1='||:F1||' AND FIEL2='||:F2|| IIF(:pCondition=1,' AND FIEL3='||:F3,'')  INTO .. DO ..   TABLE1 PK =FIELD1,FIELD2,FIELD3  running the query gives a NATURAL PLAN How to make it use the index? Index is used