SQL Techniques 周六维多利亚 IT Club 分享

首先祝各位 马年健康快乐，马上来钱，马到成功，龙马精神，万马奔腾, 春风得意马蹄疾。

公告板：

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