木匠的微型博客 Charlie Twitter

    follow me on Twitter

    Monday, January 13, 2014

    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

    No comments: