Database Tuning and Buffer Cache Hit ratio
In this post, we continue our series on performance tuning. We present the concepts of logical reads and physical reads,[…]
Read more
Category: Database tuning
Database Tuning, SQL Execution Plan and Query Rewrite
In a previous post, we present an introduction to database tuning. In this post, we’ll talk about SQL execution plans[…]
Read more
Database Tuning – What is it?
Database tuning is a key activity of DBA professionals. It consists on making (or suggesting) performance oriented changes, which may[…]
Read more