>
> Hi Tanz!
>

Hi Set,

> I hope you are not saying that SP_RUNMANYTIMES executes 2300000
> million times expecting and that you want this to complete quickly.

No, I check the performance analysis of SP's and the numbers are total READ
COUNTS of rows.

>
> What I would recommend you to do, is to take each of the queries,
> prepare them and report back to this list the plan as well as index
> statistics. The query

Actually, I have no idea about PLAN's and I dont know how to use it in SP.
There is no example around here.

> SELECT M1.MUH_HAREKETKODU,SUM(M1.MUH_MIKTAR) AS GIDERTOPLAM
> FROM MUHASEBE_MIKTARLAR_ISARETLI M1
> JOIN HAREKETKODLARI HK1
> ON HK1.HAREKETKODU = M1.MUH_HAREKETKODU
> WHERE
> (HK1.HAREKETKODU_TIPI = 'GIDER')
> AND
> (M1.MUH_TARIH BETWEEN :BASLATARIH AND :BITISTARIH)
> GROUP BY M1.MUH_HAREKETKODU)
>
> is particularly interesting. It would also be good to have some index
> statistics.

I dont know how to supply index statistics. Can you explain me? :( I am
sorry.

PLAN SORT (JOIN (HK1 INDEX (IDX_HAREKETKODLARI_TIPI),M1 HK INDEX
(PK_HAREKETKODLARI_HARKODU),M1 MUH INDEX (FK_MUHASEBE_HAREKETKODU)))

>
> Set
>