|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
by Suresh Kumar ParvathaneniConsider the following example:
SELECT * FROM SPFLI
%_HINTS ORACLE 'INDEX("SPFLI" "SPFLI~001")'
In the above example, 001 is the secondary index of the table SPFLI. It's a
well-known fact that the efficient way of retrieving data from the database
tables is by using secondary indexes. Many database vendors provide the
optimizer hints for the same. From SAP® v4.5, optimizer hints can be provided by
the %_HINTS parameter. This is dependent on the database systems that support
optimizer hints. The point to be noted here is these optimizer hints are not
standardized by the SQL standards. Each database vendor is free to provide the
The code was written in R/3 4.6C.
Consider the following example:
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