Alibaba DBA Team

这里记录着阿里巴巴数据库团队成员的点点滴滴

Archive for February 19th, 2009

oracle三个版本中对哈希外连接的优化方式

Thursday, February 19th, 2009

哈希外连接在oracle中的处理方式 , 通常我们认为都是主表作为构建哈希table的表, 而子表则作为匹配的表.
今天看了下9i, 10g, 11g的<<Performance Tuning Guide>>, 发现并不是这样的. 三个版本中的描述分别如下:

Posted in 大话技术 | 2 Comments »

阿里巴巴DBA出品

Search for:
February 2009

M T W T F S S

« Jan Mar »

1

2 3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 26 27 28
Tags
11g Add new tag Architecture ASM BI Clob DBA DW Flash Cache free buffer waits group by heartbeat index Infobright Innodb join jonathan lewis linux ha mlc MyIsam MySQL mysql ha mysql release MySQL Replication MySQL书籍 MySQL复制 MySQL限制 nested loop Oracle order by performance plan stability slc Sql tuning ssd ssd 存储 stored outlines SUN 三亚旅游全角半角写书性能架构表大小项目管理
最新文章
最新评论
- Jeff_dowa on 一个经典的sql实现
- sgb on ORACLE BITMAP INDEX
- 保健品网 on 《MySQL性能调优与架构设计》最新勘误
- 夜雨 on 使用数据库存图片
- Mablevi on MySQL Query Cache 小结
归档日志
- July 2010 (1)
- May 2010 (3)
- March 2010 (4)
- February 2010 (7)
- January 2010 (3)
- November 2009 (3)
- October 2009 (1)
- September 2009 (1)
- August 2009 (1)
- July 2009 (6)
- June 2009 (8)
- May 2009 (7)
- April 2009 (2)
- March 2009 (8)
- February 2009 (8)
- January 2009 (6)
- December 2008 (9)
- November 2008 (6)
- October 2008 (3)
- September 2008 (6)
- August 2008 (3)
- July 2008 (6)
- June 2008 (4)
- May 2008 (8)
- April 2008 (8)
- March 2008 (15)
- February 2008 (13)
- January 2008 (19)
DBA的空间
站点导航
Pages
- 关于我们