2015-k-db-jonathan_lewis-five_hints_for_optimising_sql-praesentation
5墨值下载
1
Five Hints for Optimal SQL
Jonathan Lewis
jonathanlewis.wordpress.com
www.jlcomp.demon.co.uk
Five hints
2 / 41
Jonathan Lewis
© 2008 - 2015
Who am I ?
Independent Consultant
32+ years in IT
27+ using Oracle
Strategy, Design, Review,
Briefings, Educational,
Trouble-shooting
Oracle author of the year 2006
Select Editor’s choice 2007
UKOUG Inspiring Presenter 2011
ODTUG 2012 Best Presenter (d/b)
UKOUG Inspiring Presenter 2012
UKOUG Lifetime Award (IPA) 2013
Member of the Oak Table Network
Oracle ACE Director
O1 visa for USA
2
Five hints
3 / 41
Jonathan Lewis
© 2008 - 2015
The Problem
• "Left-deep"
• Bad choice of transformation
• Restrictions on transformations
• Bad Estimates
• Bad join order
Five hints
4 / 41
Jonathan Lewis
© 2008 - 2015
Left-deep tree
The optimizer’s strategy is always to work towards a ‘left-deep’ tree. We
traverse the tree from the bottom left corner going across then up.
of 21
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论