file index usage

[Former Member]

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

[Jelena_Perfiljeva]

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>.

[RaymondGiuseppi]

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

[RaymondGiuseppi]

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