topic Performance issue for reading the data from large table in Application Development and Automation Discussions

Performance issue for reading the data from large table

Former Member — Thu, 12 Nov 2009 12:26:32 GMT

hi masters,

I have one query in my program using which i m fetching the data from a table having 14,000,000 number of records.

i have 2 primary index fields in this table out of that i m using 1 field for selection and i m using other 3 fields also for selection for which i have secondary index. After all this its taking 40 min to fetch the data from that table.

Is there any solution to reduce the time to fetch the data. pl help me.

regards,

vicky.

Moderator message - Please see before posting - post locked

Edited by: Rob Burbank on Nov 12, 2009 9:27 AM

Re: Performance issue for reading the data from large table

Former Member — Thu, 12 Nov 2009 12:29:25 GMT

Use ST05 transaction and do SQL trace and see the explain plan to check how the indexes are being used, based on that you can decide if you want to modify your query or index

-Saravanan

Re: Performance issue for reading the data from large table

Former Member — Thu, 12 Nov 2009 12:46:27 GMT

You can use an index. Which code are you using to read the information. Also avoid to use the 'select *' statement.

Regards

Thomas

Re: Performance issue for reading the data from large table

Former Member — Thu, 12 Nov 2009 14:21:48 GMT

the order of the fields in the index is important:

what is the primary key and what the secondary and what is the SELECT statement?

How many records do you read?