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: 

Database Hints

Former Member
0 Kudos

Hi All,

I am working on performance issue..The requirement is like : The user can enter the table and Index name in the Selection screen.

select query should pick the data from Database table based on the index.....

In where condition i have to incorporate the Oracle hints.((%_HINTS ORACLE )...

Can any one suggest me how to proceed.....

Jayan.

4 REPLIES 4

ThomasZloch
Active Contributor
0 Kudos

You can send both the DB table name and also Oracle hints syntax dynamically (as variable contents) to the Open SQL statement, so this should be possible.

Please read ABAP online documentation for SELECT and search for additional information on "%_HINTS ORACLE", I've found some interesting threads after a quick search.

Thomas

Former Member
0 Kudos

You could do something like the following to build your dynamic select statement:

concatenate 'INDEX("' p_table '", "' p_index '")' into lv_hint.

  select single *
    from (p_table)
    into ls_result
    %_HINTS ORACLE lv_hint.

This is a similar thread and was solved:

Former Member
0 Kudos

?? a user is supplying a table and index name? Why would you do that? If they don't supply values for the fields named in the chosen index, you're going to read the table end-to-end anyway.... Why would a user even be reading a database table?

0 Kudos

Good point actually. Maybe he's planning a little "don't trust the CBO" kind of analysis program, to compare runtimes of different access paths?

Thomas