Performance Issues

Hello all,

I have couple of questions regarding performance tuning of applications.

1. Which of the following is better from performance point of view.

a) SELECT SINGLE ... inside a LOOP or

b) SELECT XXX. YYYY INTO TABLE ZZZ FROM table... and then READ TABLE zzz ... inside a LOOP.

2. I am planning to discuss with basis guys over creating a new index with all the fields used in the WHERE clause. Will creating a new index be productive????

And one more question. When I did ST05 on my program I got a trace list. I displayed the trace list by SQL statements. But it is not clear which SELECT on which TABLE is taking more time. I will appreciate if someone throw little insight on working with trace list.

Thanks,

Somen