Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP Dynamic HINTS ?

stefan_koehler
Active Contributor
0 Kudos

Hello application development guys,

the DSAG (a german SAP user group) is presenting a speech called "Performance optimization with dynamic hints".

As far as i know is that we can use "static" hints for database queries (hard coded in ABAP)... but i don't know any possibility to generate the hints "dynamically".

Are there any other cases in ABAP where HINTs are used or is what does it mean "optimization with dynamic hints" ?

I can't imagine that database hints are generated dynamically....

Thanks and Regards

Stefan

2 REPLIES 2

matt
Active Contributor
0 Kudos

Perhaps the HINTS can be included in the dynamic definition of the WHERE clause?

I don't know this is the case, but I can't see a reason why it shouldn't be.

matt

stefan_koehler
Active Contributor
0 Kudos

Hello Matt

>> Perhaps the HINTS can be included in the dynamic definition of the WHERE clause?

What do you mean with "in the dynamic definition of the WHERE clause"?

I mean SQL Hints for database access like this one:


SELECT *  FROM TAB
WHERE TYPE = pa_input
%_HINTS ORACLE 'index(TAB_I"J")'.

Where can there be something dynamic in the coding? The HINT is hard coded to tell the database optimizer the access path.

Regards

Stefan