HI,
I have used following query in ABAP code in ABAP extract stage (in Datastage)
SELECT
bukrs
belnr
gjahr
INTO TABLE it_bkpf
FROM bkpf
WHERE cpudt >= 'date' OR aedat >=.'date'
The performance is very slow for 4000 records it is taking 22 minutes.
If i use the query
SELECT
bukrs
belnr
gjahr
INTO TABLE it_bkpf
FROM bkpf
WHERE cpudt >= 'date'
Then i got almost same records but it took only 1 minute.
But i must use first SQL .
Can anyone tell me how can i improve performance.?
Thanks in advance.
Pavan