© Stelios Charalambides  2017

Stelios Charalambides, Oracle SQL Tuning with Oracle SQLTXPLAIN, 10.1007/978-1-4842-2436-6_19

19. Comparing Execution Plans

Stelios Charalambides

(1)New Hampton, New Hampshire, USA

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 to correct the bad execution plan. In Chapter 8 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 ...

Get Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.