Hi @rajesh yadav ,
Indeed, it is difficult to define what execution speed a query should have. Because there are many factors that affect the execution speed, such as the common ones:
No index or index is not used (this is the most common problem of slow query and a defect in program design)
I/O throughput is small, forming a bottleneck effect
The query is not optimized without creating a calculated column
Not enough storage
Slow network
The amount of data queried is too large (multiple queries can be used, other methods to reduce the amount of data)
Lock or deadlock (this is also the most common problem of slow query, it is a defect of program design)
sp_lock, sp_who, active user view, the reason is to read and write resources competition
Unnecessary rows and columns were returned
The query statement is not good and not optimized.
So it is difficult for us to provide you with practical advice. As far as tsql is concerned, we can only provide you with help in optimizing statements.
If you have any question, please feel free to let me know.
Regards
Echo
If the answer is helpful, please click "Accept Answer" and upvote it.