February 2012
M T W T F S S
« Apr    
 12345
6789101112
13141516171819
20212223242526
272829  

Interesting things about index cardinality and cost calculation

For the following statement, 9i, 10g  and 11g output the different cardinality and cost.

create table t1
nologging
as
select
trunc(dbms_random.value(0,25)) n1,
rpad(’x',40) ind_pad,
trunc(dbms_random.value(0,20)) n2,
lpad(rownum,10,’0′) small_vc,
rpad(’x',200) padding
from
all_objects
where
rownum <= 10000
;
update t1 set n1 = [...]

XMLType, its storage model and index?

XMLType is an abstract type for programming, whose storage model can be unstructured storage or structure storage. 
Oracle XML DB uses XML schema as a mechanism for defining how the contents of an XMLType should be stored inside the database. Currently Oracle XML DB provides two options:

Unstructured storage. The content of the [...]