商品描述
Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole.
Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and when it's better to turn them off.
- Quickly tune any SQL statement no matter how complex.
- Build and tune test cases without affecting production.
- Use the latest tuning features with confidence.
商品描述(中文翻譯)
《Oracle SQL Tuning with SQLTXPLAIN》是一本實用指南，介紹如何像Oracle的專家一樣進行SQL調優，使用一個名為SQLTXPLAIN的免費下載工具。透過這個簡單的工具，您將學會如何調優即使是最複雜的SQL，並且能夠快速完成，而不需要經歷通常與調優相關的巨大學習曲線。
這本書以現實世界的問題為基礎，幫助您重新獲得系統資源，並避免整體性能中最常見的瓶頸——調優不當的SQL。您將學習優化器的運作方式，如何利用其最新功能，以及何時最好關閉這些功能。
- 快速調優任何SQL語句，無論其多麼複雜。
- 在不影響生產環境的情況下建立和調優測試案例。
- 自信地使用最新的調優功能。
