Abstract
Welcome to the world of fast Oracle SQL tuning with SQLT. Never heard of SQLT? You’re not alone. I’d never heard of it before I joined ORACLE, and I had been a DBA for more years than I care to mention. That’s why I’m writing this book. SQLT is a fantastic tool because it helps you diagnose tuning problems quickly. What do I mean by that? I mean that in half a day, maximum, you can go from a ‘slow’ SQL to having an understanding of why the SQL is malfunctioning, and finally, to knowing how to fix the SQL. This of course assumes that your SQL can run faster. Some SQLs are just doing their best with the data and what you are asking them to do. It’s not miraculous, but it’s pretty close.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2017 Stelios Charalambides
About this chapter
Cite this chapter
Charalambides, S. (2017). Introduction. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2436-6_1
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2436-6_1
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2435-9
Online ISBN: 978-1-4842-2436-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books