Archive for 六月, 2006

first_rows_n和all_rows的区别

Published by
wanghai
六月 30, 2006 in Oracle. 2 Comments

first_rows_n和all_rows都是oracle optimizer_mode的选项,他们有什么区别呢,会对优化器产生怎么样的影响呢?让我们一起来解开迷题.

Continue reading ‘first_rows_n和all_rows的区别’

and_equal,index_join,index_combine

Published by
wanghai
六月 22, 2006 in Oracle. 0 Comments

and_equal,index_join,index_combine这三种都是oracle利用索引关联获得数据的方法,三者的目的都是为了最大限度的利用索引,减少回表的代价.但是三者的实现方法是有区别的,下面一一来分析.
Continue reading ‘and_equal,index_join,index_combine’

About

You are currently browsing the Oracle & Starcraft weblog archives for the month 六月, 2006.

Longer entries are truncated. Click the headline of an entry to read it in its entirety.

Latest

RSS

Subscribe

Subscribe to my RSS Feeds

Archives

Categories