Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Secondary index

Hi,

I have created a secondary index ZA2 for table LTAK with fileds LATER, PASSD and KQUIT.

In my Where clause:

Select * into <itab> from LTAK

where lgnum = plgnum AND

Kquit = 'X' and

passd = space

%HINTS MSSQLNT 'TABLE %TABLE% INDEX([LTAK~ZA2])'.

Is there anything wrong with Where clause, because i have not seen the better performence.

Thanks in advance.

narasimha

Tags:
Not what you were looking for? View more on this topic or Ask a question