Regd SELECT ENDSELECT and FOR ALL ENTERIES

Hi All,

I have an extraction where i am extraction some data from matrial master and the for these materials i have to get the plant details and material text.

Here my problem is that i have checked the extraction using <b>SELECT ENDSELECT Loop</b> and Also <b>FOR ALL ENTRIES</b>.I analysed both the performance file using se30.

The result is asfollows.

<u><b>FOR ALL ENTRIES</b></u>

ABAP - 82.2%

DB - 17.8%

Time for Execution - 784 Sec

<u><b>SELECT ENDSELECT LOOP</b></u>

ABAP - 36.9%

DB - 63.1%

Time for Execution - 224 Sec

Is it good to use FOR ALL ENTRIES than SELECT Loop because the DB hit is less in FOR ALL ENTRIES.

Is this wright or can i use SELECT LOOP.

Thanks&Regards,

Siva