ABAP Dynamic HINTS ?

[stefan_koehler]

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

[matt]

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]

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