topic Re: Reg:Indexing in Application Development and Automation Discussions

Reg:Indexing

former_member197425 — Thu, 09 Apr 2009 07:43:30 GMT

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?

Re: Reg:Indexing

ThomasZloch — Thu, 09 Apr 2009 07:55:15 GMT

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

Re: Reg:Indexing

Former Member — Thu, 09 Apr 2009 07:56:57 GMT

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