There are few thing which we should keep in mind while Selecting data through ‘for all entries’ -
1. Using FOR ALL ENTRIES IN, must ensure driver table is not empty, and does not contain duplicate entries
2. Suitable only for small quantities of data. If you want to read large quantities of data, use FOR ALL ENTRIES IN in exceptional cases only!
3. Each entry in this table is translated into an OR condition for the WHERE statement by the database system. Especially if the FOR ALL ENTRIES statement is combined with AND statements the resulting complex SQL statement impacts the performance.
Thursday, December 20, 2007
SAP ABAP Performnace consideration while using ‘for all entries’
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment