Tried + 0 no improvement.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd

>Could you try and change the "order by" to something like:
> order by T.TRANSREF+0 desc (or T.TRANSREF||'' if TRANSREF is char/varchar)
>in an attempt to avoid the "INDEX (TRANSACTIONNOTE_TRANSREF)" in the plan.
>
>
>--
>Aage J.
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>