topic Re: Seconday index in open sql in Application Development and Automation Discussions

Seconday index in open sql

Former Member — Wed, 02 Dec 2009 12:20:05 GMT

Hi All,

After creating Secondary Index, how can we use the same in SQL Statement and also how can we check or trace its working or not . Can any one explain me .

Thanks in Advance.

Sudhakar Reddy.A

Re: Seconday index in open sql

Former Member — Wed, 02 Dec 2009 12:26:56 GMT

Hi!

SAP will handle the indexes automatically, you don't have to code anything special for this in your select statemenets.

If the performance of the selection is better, it works, if not, it doesn't.

Regards

Tamás

Edited by: Tamás Nyisztor on Dec 2, 2009 1:27 PM

Re: Seconday index in open sql

Former Member — Wed, 02 Dec 2009 12:45:11 GMT

write your where clause statements in the same order that the index fields appear, then utilize trace (ST05) and "describe" the OPEN table statement....drill down...you'll see the index that the database optimizer chose to use.

Re: Seconday index in open sql

RaymondGiuseppi — Wed, 02 Dec 2009 12:57:47 GMT

Open SQL will select the index from the selection and sort criteria. (Look via ST05 and such tools)

Nevertheless you can force the choice of index via a %_HINTS clause in the SQL SELECT statement. Look at OSS [Note 129385 - Database hints in Open SQL|https://service.sap.com/sap/support/notes/129385] and then at the note relative to your DB.

Regards,

Raymond