I have a problem in fetching records from a Z-table.
<b>Requirement:</b> I have Z-table which will fill every day by XI interface - by the end of the business day SAP program will take all the data from table and create a sales order. Once sales order is formed program modify the Z-table with 'X' in the one of the field to identify whether it is processed or not
I have created secondary index on Process field to read select query Faster.
Select query is taking more than 1 hour to retrieve 1 lakhs records.
Is there any better way to fetch data from Z-table?
Your suggestions are highly respected.
Suresh Babu Karanam