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.