Reg:Indexing

[former_member197425]

Hi,

Can anyone please tell help me out from this issue.My issue is i developed a custom transaction but in that the select query from a standard table is taking more time (18min) and that table contains 23lakhs records.Then how could i improve the performance .I came to knew that Indexing can help out but i am new to this .Can anyone explain me how to create indexing and to improve my transaction performance?

[former_member197425]

Hi,

Can anyone please tell help me out from this issue.My issue is i developed a custom transaction but in that the select query from a standard table is taking more time (18min) and that table contains 23lakhs records.Then how could i improve the performance .I came to knew that Indexing can help out but i am new to this .Can anyone explain me how to create indexing and to improve my transaction performance?

[ThomasZloch]

Please post your SQL statement here, a new index is only the last resort, usually a better access path can be recommended.

And just like we're posting in English here, please write "2.3 million" instead of "23 lakhs". I learned about lakhs and crores from Wikipedia, but a lot of people might not know what the heck it is.

Thomas

[Former Member]

Hi,

Indexing is not the final solution, it is how you have designed the query and how you make use of the existing indices is the key for tuning the performance.

Other than that please search on SCN for your query. You will find loads of material about your issue.

regards,

Advait