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