Hi All,

I Created a View , based on that view I create a Stored procedure. When I execute the Stored procedure it is taking 25 minutes. I checked all indexes and created new indexes and dropped few unnecessary indexes and ran then SP this time it took 21 minutes. Can someone look into the My view and SP and let me know any modifications.

• Edited by NaveenCR 7 hours 16 minutes ago

Could you please paste the execution plan? 

Our DB guys resolved the issue, by adding extra ram to the server and now my queries are running faster.

• Proposed as answer by Praveen Rayan D'sa 6 hours 53 minutes ago

ok great you might close this thread.