topic Re: Select Query ... in Application Development and Automation Discussions

Select Query ...

Former Member — Thu, 07 Jul 2005 04:34:49 GMT

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.

Re: Select Query ...

Former Member — Thu, 07 Jul 2005 04:55:44 GMT

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

Re: Select Query ...

Former Member — Thu, 07 Jul 2005 04:55:59 GMT

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.

Re: Select Query ...

jayanthi_jayaraman — Thu, 07 Jul 2005 08:15:44 GMT

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=59572