There are many programming language to develop software like C#, Java, ASP.net, PHP, Python. How to write efficient and optimized code?
Database tuning is not limited to queries and database objects. Let's assume all the queries of an application are tuned. Database design is correct. But application code has badly written. Application is never going to perform well. Database tuning is not only task of database developers but it is also task of programmers who write the codes. Here we are going to discuss about best practices for writing application code from database tuning point of view.