Skip to Content
author's profile photo Former Member
Former Member

HINTS in Select Statement

Hi,

Can anybody explain me why HITS keyword is used with SELECT statement, whats the use of if, How to find the HINTS for a particular table.

SELECT recn, recnroot, ippers

INTO CORRESPONDING FIELDS OF TABLE <ITAB1>

FROM CCIHT_IP

FOR ALL ENTRIES IN <ITAB2>

WHERE ippers = <ITAB2>-ippers

AND valfr LE sy-datum

AND valto GE sy-datum

AND iptype = 'INJ'

%_hints db2 '&max_blocking_factor 500&&max_in_blocking_factor 500&u2019.

-Rajiv

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2009 at 08:44 AM

    % HINTS is used to give particular instructions to the database when executing the SELECT statement.. in your case your database seems to be DB2 and then the two parameters are being set to the values specified probably to increase performance

    Note 150037 - Database hints in Open SQL for DB6 (DB2 for LUW) should help!

    Edited by: Saravanan Ramasamy on Nov 12, 2009 9:49 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2009 at 08:25 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 12, 2009 at 09:05 AM

    Hi,

    Complex database statements or large numbers of secondary indexes that can be very

    similar make it difficult for the database optimizer and the R/3 database interface to process

    most efficiently. In some database systems, you can expressly influence decisions made by

    database optimizer by what are known as hints.

    Ex- %_HINTS ORACLE '&SUBSTITUTE VALUES&'.

    Search with HINTS in SELECT STATEMENT you will get so many ans

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.