Hi gurus,
I've created an index , but my problem is the right way to call it. i've allready seen several ways here in the forums and dont know witch one is right.
My index has the Z04 name and i'm calling this way :
SELECT t1~bukrs t1~belnr t1~dmbtr
APPENDING CORRESPONDING FIELDS OF TABLE tab_dados
FROM bsak AS t1 INNER JOIN bkpf AS t2
ON t1~bukrs = t2~bukrs AND
t1~belnr = t2~belnr AND
t1~gjahr = t2~gjahr AND
t1~blart = t2~blart
WHERE t1~bukrs IN r_bukrs AND
t1~zuonr IN r_economica AND
t1~gjahr = ano AND
( t1~budat IN so_date OR t1~augbl IN so_date ) and
T1~BLART in R_TIPOS_DOC AND
t1~hkont IN r_contas AND
t1~xref1 LIKE p_fundo AND
t1~xref3 IN r_fictr AND
t2~stblg = ''
AND t1~monat IN so_perio
%_HINTS ORACLE 'INDEX(BSAK BSAK~Z04)'..
the compiler didn't gave any error but just in case...
Is this right??
thanks in advance,
Regards,
João Martins