Can I read SQL Tuning Best Practices Guide on EtoBox?
SQL Tuning Best Practices Guide by harshdba is a document available to read on EtoBox.
What is SQL Tuning Best Practices Guide about?
This document discusses various techniques for tuning SQL statements for performance. It recommends establishing a tuning environment, indexing wisely to support queries, reducing unnecessary parsing, avoiding accidental table scans, optimizing necessary scans, optimizing joins, taking advantage of the cost-based optimizer, and considering PL/SQL for complex queries. The overall goal is to follow a methodology to tune SQL statements at the appropriate time and achieve maximum performance.
- Author
- harshdba
- Language
- EN