|Subject||Re: [firebird-support] Why there are always one natural file in query|
> My question is how do I avoid using "PLAN SORT" because is very slow, thedo you have an index on ticket.ticket_pid and ticket.ticket_no?
> temp. sort file sometime exceed 2G.
If not, create them and you should see a difference.
Try not to use underscores in your tablenames in future, it makes reading