公告板：
SQL Techniques 周六IT Club分享
______________________________
时间: 1月18号 星期六 下午2点半
地点: 2121 Cedar Hill Cross Rd. EBC church second floor meeting room.
主讲人: 木匠
本次主题是: SQL Techniques.
去年春天回中国，得了一场怪病，颓废了大半年。
终于康复了70%, 赶紧回来跟大伙分享数据库知识, 为社区做贡献。
欢迎前来捧场。
Agenda
What do you need to write “good” SQL
The Schema Matters
Knowing what is available
Using rownum (yes, to 'tune')
Scalar subqueries
Analytics
Some hints
Don’t tune queries!
Other things
Materialized Views
With subquery factoring
Merge
…
Access Paths
There are a lot of them
There is no best one (else there would be, well, one)
A little bit of physics
Full scans are not evil
Indexes are not all goodness
How the data is managed by Oracle
high water marks for example
IOT’s, clusters, etc
What your query needs to actually do
Is that outer join really necessary or “just in case”
Thanks,
Charlie 木匠 | Database Architect Developer
Posts
