topic Re: file index usage in Application Development and Automation Discussions

file index usage

Former Member — Fri, 12 Jan 2007 07:36:41 GMT

Hello Friends,

After creating and index on a file how can I address this index in my ABAP program (ie select staement)?

Thx in advance.

Ali

Re: file index usage

Jelena_Perfiljeva — Fri, 12 Jan 2007 15:40:45 GMT

How did you create an index on <b>a file</b>? SELECT statement is to select the data from database, not to read a file.

For information on the SELECT optimization see 'Performance hints for Open SQL Programming' chapter in ABAP help or <a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3b7e358411d1829f0000e829fbfe/content.htm">here</a>.

Re: file index usage

RaymondGiuseppi — Fri, 12 Jan 2007 16:12:49 GMT

Abap and DB server chose dynamicallly from which index they read data. If you use the exact key of the index the program MAY (and usually do) use it.

regards

Re: file index usage

RaymondGiuseppi — Fri, 19 Jan 2007 09:11:47 GMT

Re:

A collegue informed me about the existence, according to the Database System, of a parameter %_HINTS which on certain system allows to force the choice of the index used by SELECT

Ex :%_HINTS MSSQLNT 'TABLE <tablename> ABINDEX(<suffix>)'. on a MS SQL Server

Look at OSS note with keywords "Open SQL", "%_HINTS" and filter result with your Database System. (DB2, Oracle, and the like)

Best regards