First thing, if you want "min", you should have your cursor def as "order by trans_id asc" and not "order by trans_id desc". I think this just a minor thing.

On performance front, I think both will be the same. You may get better result if you have the IOT.