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