oracle - Does a reverse key index help if i use an incremental sequence to insert subsequent values -
i understood basic rationale reverse key index reduce index contention. if have 3 numbers in index: 12345, 27999, 30632, can see if reverse these numbers, next number in sequence won't hit same leaf block.
but if numbers :12345,12346,12347, next numbers 12348,12349 (incremented 1) hit same leaf block if index reversed: 54321,64321,74321,84321,94321.
so how reverse index helping me? supposed particularly while using sequences
if we're talking sequence-generated value, can't @ 5 values , draw many conclusions. need think data has been inserted , data inserted in future.
assuming sequence started @ 12345, first 5 values inserted sequentially. sixth value 12350. reverse , 05321 go far left of index. you'd generate 12351. reverse 15321 , that's again toward left-hand side of index between first value generated (54321) , recent value (05321). sequence generates new values, they'll go further right until resets every 10 numbers , you're inserting far left-hand side of index again.
Comments
Post a Comment