Skip to Content
0
Former Member
Feb 12, 2007 at 04:26 PM

Problem with INDEX

40 Views

When the following SELECT SENTENCE is executed:

SELECT DISTINCT bukrs vbeln kunag fkart waerk fkdat

FROM vbrk CLIENT SPECIFIED

INTO TABLE ti_factura

WHERE mandt = '400' and fkart IN p_fkart

AND fkdat between p_budat1 and p_budat2

it alway performs a sequential search dispite we've created and activated an index with these fields:

MANDT

FKART

FKDAT

What can I do to get the SELECT use the index ?

Regards,