- 博客(5)
- 资源 (6)
- 收藏
- 关注
原创 rowid理解误区解释
做培训的时候认为rowid的前六位存储的是object_id,其实是错误的它代表的应该是data_object_id.关于rowid请看:http://blog.csdn.net/zhou689689/article/details/8775251官方解释:OBJECT_IDNUMBERNOT NULLDictionary object number of
2013-05-30 11:34:46 644
转载 INDEX FULL SCAN 与 INDEX FAST FULL SCAN
INDEX FULL SCAN 与 INDEX FAST FULL SCAN两个长相差不多,乃是一母同胞,因此既有其共性,也有其个性。两者来说其共性是不用扫描表而是通过索引就可以直接返回所需要的所有数据。这对提高查询性能而言,无疑是一个难得的数据访问方式之一,因为索引中存储的数据通常是远小于原始表的数据。下面具体来看看两者之间的异同。 一、何时INDEX FULL SCAN 或 I
2013-05-28 23:12:40 611
转载 行迁移与行链接
row chain:When a row is too large to fit into any block, row chaining occurs. In this case, the Oracle devide the row into smaller chunks. each chunk is stored in a block along with the necessary poit
2013-05-28 18:15:17 617
原创 理解index skip scan
官方文档:Anindex skip scanuses logical subindexes of a composite index. Thedatabase "skips" through a single index as if it were searching separate indexes. Skip scanning is beneficial if there are fe
2013-05-28 17:46:41 1207
原创 oracle中sql分析函数
分析函数能够将复杂的需求使用简单的sql实现,而且执行效率较高。测试环境:SQL> select * from v$version where rownum=1;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Editio
2013-05-16 23:16:31 608
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人