topic Re: ABAP Dynamic HINTS ? in Application Development and Automation Discussions

ABAP Dynamic HINTS ?

stefan_koehler — Sat, 24 Nov 2007 12:00:50 GMT

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

Re: ABAP Dynamic HINTS ?

matt — Sat, 24 Nov 2007 17:27:50 GMT

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

Re: ABAP Dynamic HINTS ?

stefan_koehler — Sat, 24 Nov 2007 19:03:19 GMT

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