Imagine you’ve come to conquer the planet SQL but those pesky aliens are constantly changing their bind variable values presenting skewed data all the time, and sometimes not even reporting how many rows there are. The name of the game would be Adapt and Conquer. Another adjective you could use would be Dynamic. Your space fleet’s motto might well be “Victory through Adaptive and Dynamic Plans.” In the world of SQL plans, Adaptive Cursor Sharing has already been introduced in the previous chapter. ACS deals with different combinations ...
© Stelios Charalambides 2017
Stelios Charalambides, Oracle SQL Tuning with Oracle SQLTXPLAIN, 10.1007/978-1-4842-2436-6_10
10. How to Work with Adaptive Plans
Stelios Charalambides1
(1)New Hampton, New Hampshire, USA
Get Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition, Second Edition 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.
