Select Query ...

[Former Member]

Hi Friends,

Could anybody help me in explaining how this select query works. To be more specific what is the function of

%_HINTS ORACLE 'INDEX("&TABLE&" "BSID~Z6")'.

This is the query :

SELECT mandt bukrs kunnr umskz

FROM bsid APPENDING TABLE ws_bsid

FOR ALL ENTRIES IN customer

WHERE kunnr = customer-kunnr AND umskz = ' '

%_HINTS ORACLE 'INDEX("&TABLE&" "BSID~Z6")'.

Best Regards,

Gayathri.

[Former Member]

Hi Gayathri ,

The query is trying to use the index Z6 of the table BSID to select the data. Use of index makes it faster to retrieve data from the database table .

Thanks and Regards ,

Sudipto

[Former Member]

Hello Gayathri,

I see that you are a new user here. Welcome to SDN and hope you have a nice time here.

Coming to your question, it has been discussed many times in this forum. You just search the forum for the word HINTS and you will get the required answers from the hits that the search gives you.

for example, you can look at

and many others...

And please don't forget to reward the answers that have helped you.

Regards,

Anand Mandalika.

[jayanthi_jayaraman]

Hi Gayathri,

Check this link.In that they explained it with example[check Give me a hint].

http://www.intelligententerprise.com/channels/applications/columns/archive/abap4.jhtml?_requestid=59...