Re: Faster key lookup

[Steve Richter <stephenrichter@xxxxxxxxx>]

was going to suggest "fetch first row only". But that still does the
count.  The first row is that of the output. Which is the count itself.

I would fetch first row only into a field with a nullable indicator.

Maybe upgrade to a faster system?

On Wed, Jun 27, 2018 at 8:30 PM, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:
> I have a *SRVPGM that calls a procedure a lot, and I need to speed it up.
>
> Here's the entire code for the procedure:
> EXEC SQL
>   Select count(*)
>     Into :rc
>     From MY_TABLE
>     Where COLUMN1 = :local1 and COLUMN2 = :local2 and COLUMN3 = :local3
>            And (COLUMN4 = :local4 or :local4 = '');
> Return (SQLSTATE = '00000' and rc > 0);