Re: Questions on hard coded vs bind variable performance

Użytkownik dave_93_98_at_yahoo.com napisał:

> Hello,
> Select trn.lot, MAX(txn_id) As txn_id
> into nLot, nID
> From transaction trn, history his
> Where trn.his_ID = his.his_ID
> -- And txntime between cStartTime and cEndTime
> And txntime between '20040904 000000000' and '20040905 000000000'
> Group by trn.lot
>

I would use to_date function and would check performance.

ex. to_date(SUBSTR(cStart_time,1,10),'RRRRMMDD');

-- 
TomekB tbal_at_spam_go2_trap.pl GSM:Plus 607598532
{Peugeot 306 ST, WY - 49245,       GG: 947-891}