Slect query taking time when executed
The following is my select query
into table it_table
where zmatnr = so_matnr
and zdate = so_date
and delnum = '0'
and prtnr > '0'.
Here zmatnr and zdate are only the key fields. The other two are not. This query takes time. Shall i index those fields. Is it right. Explain the right situation to index the table.