=> Number of joins and use of complex views/cursors have to be reduced.
=> The use of the stored procedures and indexes have to be maximized.
=> The optimized use of the complex conditional checks and computer columns have to be in place.
=> Tracking of performance analysis for the query helps us in identifying the right aspects to optimize.