SQL/MySQL/ORACLE DBA Learning

Hi All, Need help In SQL server we have one table which is using in different SPs with same set of parameters but there is huge difference in execution time one is completed in 3 seconds whereas the second one is taking 5 minute Please suggest Note - already checked the Execution plan did not find anything

Are there any other tables involved in sp(5 min taking), check fragmentation, updates tats, parameter sniffing(you said same set of parameters) , sp_recompile once , check how much data processing , index scan or seek , missing index etc

Hi I'm 2017 passed out and having Non it exp from 2019 nov to 2021 sep with just 1.8Lpa , right now  backdoor lo naku kanisam oka 5 to 6Lpa package vache a job Aina prledhu without initial ippinche vallu unte reply evandi

Same batch bro