tag:blogger.com,1999:blog-302298286928742422.post2161222592486029927..comments2024-03-27T22:52:06.600-07:00Comments on #cloud blog: Tipping pointDBAHarrisonhttp://www.blogger.com/profile/16901239165682958859noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-302298286928742422.post-66859431291752282212016-08-11T06:29:50.022-07:002016-08-11T06:29:50.022-07:00Indeed. That's where the serious thinking come...Indeed. That's where the serious thinking comes in.... :-)DBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-53571028639132640932016-08-11T06:10:41.585-07:002016-08-11T06:10:41.585-07:00If you run dbms_xplan.display_cursor you can see w...If you run dbms_xplan.display_cursor you can see what the optimizer expects at each line and what it gets - if these 2 are in reasonable agreement then the optimizer has a good idea of what is going on - if they don't then just about anything can happen - the trick is working out why they are out of sync and correcting itNick Strangenoreply@blogger.com