Performance issue for reading the data from large table

[Former Member]

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

[Former Member]

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

[Former Member]

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

Regards

Thomas

[Former Member]

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?