Skip to Content
0
Former Member
Nov 28, 2008 at 09:33 AM

performance problem

18 Views

Hi all

I have one issue like this

there is one report . on executing it , it is taking more exeution time . when the execution time limit is more than 1500 sec it is going for short dump.

i have debugged the program . i found at one select statement it is taking more time .

the select stmt is like (select * from rbkp) how should i know which fields i have to select instead of select * frm rbkp table. how should i know whether i have to increase the where conditions??

finally how should i reduce the execution time limit