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

2015-08-20 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
19, 2015 4:18 PM Subject: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX   19.08.2015 14:29, 'Mr. John' wrote: > This time,adding condition this way WHERE FIEL1=:F1 AND FIEL2=:F2 AND > * (FIEL3=:F3 OR **:F3 IS NULL) * INTO .. DO .. > > is causing query to

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

2015-08-20 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
not FIELD3 COULD BE NULL, VARIABLE :F3  AND THAT MEANS NO FILTER ON FIELD3 thanks From: "liviusliv...@poczta.onet.pl [firebird-support]" To: firebird-support@yahoogroups.com Sent: Wednesday, August 19, 2015 8:00 PM Subject: Re: [firebird-support] Re: MAKE 'EXECUTE STATE

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

2015-08-19 Thread liviusliv...@poczta.onet.pl [firebird-support]
: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX ok,thanks This time,adding condition this way WHERE FIEL1=:F1 AND FIEL2=:F2 AND (FIEL3=:F3 OR :F3 IS NULL)INTO .. DO .. is causing query to be much slower ... this

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

2015-08-19 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
19.08.2015 14:29, 'Mr. John' wrote: > This time,adding condition this way WHERE FIEL1=:F1 AND FIEL2=:F2 AND > * (FIEL3=:F3 OR **:F3 IS NULL) * INTO .. DO .. > > is causing query to be much slower ... > > this WHERE FIEL1=:F1 AND FIEL2=:F2 AND * (FIEL3=:F3 **) * INTO .. DO .. > takes *0.563s* be

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

2015-08-19 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
: firebird-support@yahoogroups.com Sent: Wednesday, August 19, 2015 11:51 AM Subject: [firebird-support] Re: MAKE 'EXECUTE STATEMENT' USE INDEX   19.08.2015 10:26, 'Mr. John' wrote: > now index is used if I call > SELECT * FROM MYPROC(...) > but I use it in oth

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

2015-08-19 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
19.08.2015 10:26, 'Mr. John' wrote: > now index is used if I call > SELECT * FROM MYPROC(...) > but I use it in other procedures,no join on it just simply SELECT .. > FROM MYPROC(...) in this case I can see in the plan : > ...(MYPROC NATURAL)... That' OK. In complex plans, (MY_PROC NATURAL) just