Hi i am shashi. I am new to the DBA work. I am working for tuning of an SP. Till yesterday the SP ran for 2 hrs , but today it is taking 9hrs to run . Can anyone suggest how to start the tuning . Their are many DML statements written in SP. What the basic things should i look at . Their are around 8 to 10 tables inside the SP. Should i look at the statistics and Logical scan fragmentation. pls help me, Thanks in advance.