|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Several nested INNER JOINS are inefficient
by Sathiya Kumar
"Using several nested INNER JOIN statements can be inefficient and cause
time out if the tables become too big in the future."
Joins here (in ABAP) are not those Native SQL Joins. If you are talking
about the Core RDBMS, which mean Oracle or SQL Server, then Undoubtedly Joins
are the best.
In ABAP, these joins are first split by the ABAP processor and then sent to
the database, with the increase in DATA in production system, these joins tend
to give way if your database keeps growing larger and larger.
You should rather use "FOR ALL ENTRIES IN" (Tabular conditions),
which is a much efficient way as far as performance is concerned.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards