When working with Oracle databases, there are times when you need to optimize and homogenize the database to ensure good performance. This is also known as database tuning. In Oracle, SQL query tuning is an important part of speeding up database performance. SQL tuning is essentially the process of optimizing a database for better performance. Most tuning gains will be obtained from focusing on your SQL queries and optimizing how they function. If your queries are inefficient i.
Post a Comment. For a database developer it is a skill to write a most efficient tuned query. While query writing we generally come across some like I have written two different queries for same requirement which one is better? Join is better or sub query? When temporary will perform better and when table variable etc. Answer is very simple compare write all possible way which you can write and compare among them. Which one enjoy least that query is better among other.
Introduction to the Query Optimizer. About Optimizer Components. About Automatic Tuning Optimizer.