0
2015-k-db-jonathan_lewis-five_hints_for_optimising_sql-praesentation
111
21页
1次
墨值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
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部