topic Re: Index in Application Development and Automation Discussions

Index

Former Member — Tue, 17 Jul 2007 19:08:08 GMT

Is there any way you can specify the index that the select statement needs to use programatically or while writing your select statement.

Thanks,

ALAM.

Re: Index

RichHeilman — Tue, 17 Jul 2007 19:16:32 GMT

I think you can use the HINT.

Check this page.

http://www.intelligententerprise.com/channels/applications/columns/archive/abap4.jhtml

Regards,

Rich Heilman

Re: Index

Former Member — Tue, 17 Jul 2007 21:59:01 GMT

See the sample statement using hints.


SELECT * FROM knvh INTO CORRESPONDING FIELDS OF TABLE lvt_xknvh_sons
                            WHERE hityp = pis_xknvh-hityp AND
                                 hkunnr = pis_xknvh-kunnr AND
                                 hvkorg = pis_xknvh-vkorg AND
                                 hvtweg = pis_xknvh-vtweg AND
                                 hspart = pis_xknvh-spart AND
                                 datab <= s_date AND
                                 datbi >= s_date
             %_HINTS ORACLE 'index(knvh knvh______a)'

Re: Index

former_member196299 — Wed, 18 Jul 2007 04:06:18 GMT

hi Alam ,

Yes very well you can do so by providing a where clause and keeping all the possible criterias to make the index clear . So that what happens is , the system creates an index from the where clause itself and selects the values based on it .

Thats the way you can use the indexes programatically .

Regards,

Ranjita