Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Hints in ST05

Former Member
0 Kudos

Hi Experts,

I was checking my query in ST05. I want to give a data base hint to the query. How can I give. My database is MSSQL. The index is MARA~ZI1.

I am using the following code. The index is stored in the backend as MARA~ZI1


select MATNR
  from MARA
    With (Index (MARA~ZI1))

In the explain I get the error as Incorrect syntax near ~

Can anyone please help me resolve this issue.

Regards,

Abdullah

1 REPLY 1

Former Member
0 Kudos

select MATNR
from MARA
with ( INDEX([MARA~ZI1]))

This resolved the issue.