topic Re: HINTS in Select Statement in Application Development and Automation Discussions

HINTS in Select Statement

Former Member — Thu, 12 Nov 2009 07:10:54 GMT

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

Re: HINTS in Select Statement

Former Member — Thu, 12 Nov 2009 08:25:07 GMT

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

Re: HINTS in Select Statement

Former Member — Thu, 12 Nov 2009 08:34:48 GMT

Nothing is displayed in that link

Re: HINTS in Select Statement

Former Member — Thu, 12 Nov 2009 08:44:30 GMT

% 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

Re: HINTS in Select Statement

NAeda — Thu, 12 Nov 2009 09:05:03 GMT

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