> My question is how do I avoid using "PLAN SORT" because is very slow, the
> temp. sort file sometime exceed 2G.

do you have an index on ticket.ticket_pid and ticket.ticket_no?
If not, create them and you should see a difference.
Try not to use underscores in your tablenames in future, it makes reading
very difficult.