This discussion is archived
4 Replies Latest reply: Aug 12, 2010 11:35 AM by 791081 RSS

Regarding Performance Tuning

709017 Newbie
Currently Being Moderated
Hi All,

I have a OLTP type table with 18 lakhs data which is queried and updated hugely. Now I need to tune queries performed on the table. We already have indexes on primary key fields, foreign key fields and some check constraints, which we cant change.

Please let me know the step by step process which I can implement in order to increase the speed of most queries.

Please explain in a detailed manner.

Thanks and Regards,


  • Correct Answers - 10 points
  • Helpful Answers - 5 points