At 04:44 PM 07/02/2003 +0200, you wrote:

>At 16:11 02.07.2003 +0200, you wrote:
> >Thanks everyone. From an execution time of 39.5 s (against prod data on the
> >local server) to 70 ms is pretty good going ...
>
>Just curious as to what the successful plan looks like?
>
>Set

PLAN SORT (SORT (JOIN (C NATURAL,S INDEX (IDX_CLNT_SUB_CODE),L INDEX
(IDX_LOG_CLIENT,IDX_LOG_CLNT_SUB))))

I "guessed" at Helen's meaning, and apart from the indices you recommended,
created the following two indices :

CREATE INDEX "IDX_LOG_CLIENT" ON "LOG"("ACC_NUM");
CREATE INDEX "IDX_LOG_CLNT_SUB" ON "LOG"("SUB_CODE");

Thanks again - I really mean it - you and Helen saved my ass. :-)

Tim

BTW -

execution time for the select : 00:00:00:0491

execution time for the SP : 00:00:00:0030

:-D


[Non-text portions of this message have been removed]