jackred的专栏

 [Oracle] Index Full Scan vs Index Fast Full Scan作者：汪海 (Wanghai) 日期：14-Aug-2005　出处：http://spaces.msn.com/members/wzwanghai/ Index Full Scan vs Index Fast Full Scan index full scan和index

 如何导出并解读oracle block(非原创)DUMPING ORACLE BLOCKSBrian Peasland, Raytheon at EROS Data CenterINTRODUCTIONIn a few cases, it is desirable to dump the contents of an Oracle data block. These blocks m

 Oracle执行计划的相关概念： Rowid：系统给oracle数据的每行附加的一个伪列，包含数据表名称，数据库id，存储数据库id以及一个流水号等信息，rowid在行的生命周期内唯一。 Recursive sql：为了执行用户语句，系统附加执行的额外操作语句，譬如对数据字典的维护等。 Row source（行源）：oracle执行步骤过程中，由上一个操作返回的符合条件的行的集合。 Predic

It happened to me several times to being asked about the mysterious full table scan in CONNECT BY operations. In this post I would like to share with you some of the information I wrote about it in