Introduction to SQLTXPLAIN

Welcome to the world of fast Oracle SQL tuning with SQLTXPLAIN, or SQLT as it is typically called. 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 SQL is malfunctioning, and finally, to knowing how to fix the SQL.

Will SQLT fix your SQL? No. Fixing the SQL takes longer. Some tables ...

Get Oracle SQL Tuning with Oracle SQLTXPLAIN now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.