Skip to Content
0
Feb 16, 2006 at 03:30 PM

Select Query

12 Views

Hi,

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.

Regards,

Suresh Babu Karanam