HINTS in Select Statement

[Former Member]

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

[former_member186746]

http://www.sdn.sap.com/irj/scn/advancedsearch?query=hintsinSelectStatement++

[Former Member]

Nothing is displayed in that link

[Former Member]

% 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

[NAeda]

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