High Performance SQL
Vamsi Krishna Myalapalli, Pradeep Raj Savarapu · 2014
In the contemporary world the size of database(s) is rising exponentially. Increased size of database inevitably necessitates performance maintenance in order that performance is enhanced or sustained. The suggested model is envisioned to serve as benchmark for High Performance Database Administration via High performance SQL Query Tuning and thus improving database performance. The strategy of tuning falls on how effectively we can tune the single problem queries and database memory. This paper elucidates sundry tactics to escalate query as well as database performance and can function as a utility for Database Administrators, SQL programmers and Data Center Managers. Experimental outcomes of our analysis designate that performance is enhanced by saving CPU and I/O.