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

    Regarding Performance Tuning

      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,