- 博客(18)
- 资源 (6)
- 收藏
- 关注
转载 null value index
*** Create a table based on dba_tablesSQL> CREATE TABLE test_nulls AS SELECT * FROM dba_tables;Table created.*** Note the PCT_FREE column conatins 50 null valuesSQL> SELECT COUNT(*) FROM test_
2014-08-20 08:37:44 460
转载 Joins
There are only three join mechanisms used by Oracle: merge join, hash join and nested loop join.Here’s an important thought: all three join methods are nested loop joins with different startup c
2014-08-18 22:26:55 443
转载 Joins – NLJ
This is part one of my thesis that “all joins are nested loop joins – it’s just the startup overheads that vary”; there will be a note on “Joins – HJ” and “Joins – MJ” to follow. (For a quick referenc
2014-08-18 22:24:02 647
转载 Deleted Index Entries
Deleted Index Entries – Part I (LetIt Be) June 8, 2008Postedby Richard Foote in IndexDelete Operations, OracleGeneral, OracleIndexes, OracleMyths. trackbackJust before Ihop on a plane to do so
2014-08-16 17:11:54 1488
转载 index range scan
The index range scan starts at the root block. Then, traverses the branch blocks to find the first leaf block that contains relevant data. When it gets to a leaf block, it is the leaf block with t
2014-08-14 21:57:46 892
转载 How Btree Indexes Are Maintained (Doc ID 30405.1)
Checked for relevance on 13-Jun-2007Checked for relevance on 25-Jul-2010Although this is an older document, the information below is still relevant to later versions.PURPOSE This article explai
2014-08-13 21:42:47 684
原创 unique index与non-unique index的dump区别
10.2.0.5 on windows 2008 ASSM LMT 8K blocknon-u
2014-08-11 21:38:50 1863
转载 low_value / high_value
If you take a look at view user_tab_columns (or equivalent) you will find that its definition includes columns low_value and high_value, which give the currently known low and high value for the dat
2014-08-10 21:23:13 2071
转载 buffer and cache in linux
Regarding your query,The first row, labeled Mem, displays physical memory utilization, including the amount of memory allocated to buffers and caches. A buffer, also called buffer memory, is usually
2014-08-08 07:28:51 439
转载 Index Block Dump: Block Header Part II and Read Consistency (I Can’t Read)
OK, let’s look at the next portion of the index block dump. Following the hex dump of the block (as we ended Part I of the series) is the second part of the block header (see below): Block hea
2014-08-07 22:15:46 2310
转载 Index Block Dumps and Index Tree Dumps Part I: (Knock On Wood)
I thought before I jump into a topic that requires looking at a number of index block dumps, it might be worth briefly recapping how one goes about dumping index blocks in Oracle. A block dump is
2014-08-07 21:02:12 718
转载 KGLHD
KGLHD is not Function KGL -> Kernel Generic Library KGLHD Library cache Handle structureKGLOB - Object structureKGLNA - Name structureKGLHD -> KGLOB -> KGLNA -> KG
2014-08-05 21:48:10 1290
转载 Difference between Full Index Scans and Fast Full Index Scans
An index fast full scan reads the ENTIRE index, unsorted, as it exists on disk. It is basically using the index as a "skinny" version of the table. The query in question would only be accessing attr
2014-08-05 21:16:22 508
转载 index skip scan
n index skip scan will read the interior branch blocks - looking for changes in values. It would not read just the right and the left - it would read some of the interior branch blocks to find out w
2014-08-05 21:00:20 584
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人