Below Query Optimization Techniques should be taken care of to optimize SQL queries:
Aggregate table – Pre-populating tables at higher levels so less amount of data need to be parsed.
Move Queries to stored procedures
Remove unneeded views
Only query what you really need
Sort only when required
You should do […]