4 Replies Latest reply: Aug 12, 2010 1:35 PM by 791081 RSS

    Regarding Performance Tuning

    709017
      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,
      Baishali