How Improve Execution time of Queries
1.set Nocount on;
Set no count On use for stop count in Queriese because when we execute a Query or Store Procedures it take a time to Count of Affected Rows when we use [set Nocounton] in Query it stop the count of affected Rows in this way the Execution time will be Decrease .
2.Stored Procedure Names
When we make store Procedure Be sure Name of store Procedure can not start with SP because sql have his Own StorePocedure in Sql who handle SQL Work when we use SP in the start of Procedure name and Execute the Procedure Sql Server Search own Procedure list then search in Our Database StoreProcedure list in this way it take a long time .So if we can not use Sp in start of Procedure it search fast and take short time
3.The * Operator
Do not use the *
operator in your SELECT
statements. , use column names.
SQL Server scans for all column names and replaces the *
with all the column names of the table(s) in the SQL SELECT
statement. Providing column names avoids this search-and-replace
Share This with your friend by choosing any social account
Comments
Your Comments
You may also read following recent articles
![]() |
7 Ways to Retain More of Every Book You Read!
04-Feb-2023 11 |
![]() |
Top 5 Most Tech Skills for 2023!
04-Feb-2023 10 |
![]() |
Rupee Drops to Historic Low After Comments From Dar, PM Shehbaz Cause Market to Panic!
03-Feb-2023 18 |
![]() |
What Is Technical SEO? Basics and 10 Best Practices!
03-Feb-2023 24 |
|
Top 10 Most Important IT Skills in 2023!
02-Feb-2023 36 |
![]() |
How To Create A Content Strategy Framework!
02-Feb-2023 18 |
![]() |
Can GPT-3 pay in the future?!
02-Feb-2023 7 |
![]() |
What is digital marketing? !
02-Feb-2023 46 |
|
Top Software Testing Trends in 2023!
01-Feb-2023 67 |
![]() |
How To Make Money on YouTube in 2023!
31-Jan-2023 36 |
![]() |
The 6 Best Entry-Level Sales Jobs To Start Your Career!
31-Jan-2023 23 |
![]() |
Affiliate Marketing Program for Beginners!
31-Jan-2023 5 |