Performance tuning of program

Hi,

I have a program which going to short-dump (TIME_OUT error) as the max. time allocated by system has been exceeded. Now, I want to make some modification to the program to increase its performance. The progarm has a large no. of inner joins. All primary keys have been used. Still, the short dump occurs when the program is run. Can somebody give some tips/tricks to increase performance without much change in the code.

Thanks in advance.

Regards,

Arun Mohan