Abstract
Comparing execution plans is one of the most useful diagnostic tests you can do. If you’re lucky enough to have a good execution plan, you can use that plan as a guide to bring the bad execution plan into compliance. In Chapter 6 we talked about using SQL Profiles to apply a plan onto another database’s SQL, in order to have an emergency option. Suppose, however, you have more time to consider the difference and try to fix it properly, rather than using the SQL Profile sticking plaster. SQLTCOMPARE is the tool for the job. It will compare two target systems for the same SQL and produce a report that describes the differences. You can even import the SQLTXPLAIN repositories from the two target systems and do the comparison there. This chapter is a pure SQLTXPLAIN chapter, we will be using SQLTXPLAIN’s method SQLTCOMPARE and showing how our tuning knowledge from previous chapters can be used to diagnose a problem.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2013 Stelios Charalambides
About this chapter
Cite this chapter
Charalambides, S. (2013). Comparing Execution Plans. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4810-1_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4810-1_10
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4809-5
Online ISBN: 978-1-4302-4810-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books