Congratulations - C# Corner Q4, 2022 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Raghavendar S
2k
146
367
Improve the performance of an Query.
Mar 3 2021 4:21 AM
When we select data from multiple tables millions of records. how to improve the execution process?
My Answer: 1)Don't Use * when we use select statement, instead of * use the required columns.
2) Add an index to the columns.
3) avoid the union
Reply
Answers (
1
)
mysql in functions
Query to find the monthly payment in SQL Server