: 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
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
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