|
 |
| Slide 1:
Retiring the KEY Attribute
|
|
 |
| Slide 2:
Assertions of this Presentation
|
|
 |
| Slide 3:
A Very Brief History
|
|
 |
| Slide 4:
"Modernization"?
|
|
 |
| Slide 5:
Assumptions
|
|
 |
| Slide 6:
FREE! With every conversion to Ordered
|
|
 |
| Slide 7:
FREE! With every conversion to Ordered
|
|
 |
| Slide 8:
Don't forget! FOR EACH RECORD IN ORDER BY!
|
|
 |
| Slide 9:
More Tuning Options!
|
|
 |
| Slide 10:
A little review - M204 File Structure
|
|
 |
| Slide 11:
TABLE C
|
|
 |
| Slide 12:
Segment Entries
|
|
 |
| Slide 13:
Tuning Table C
|
|
 |
| Slide 14:
TABLE D LIST Page
|
|
 |
| Slide 15:
TABLE D BIT PATTERN Page
|
|
 |
| Slide 16:
Ordered Index - (CONCEPTUALLY)
|
|
 |
| Slide 17:
Ordered Index Advantages
|
|
 |
| Slide 18:
Tuning the Ordered Index
|
|
 |
| Slide 19:
Tuning the Ordered Index cont.
|
|
 |
| Slide 20:
What about performance?
|
|
 |
| Slide 21:
Another Factor - the Buffer Pool
|
|
 |
| Slide 22:
Buffer Pool
|
|
 |
| Slide 23:
Test Bed Detail
|
|
 |
| Slide 24:
Test Bed Detail
|
|
 |
| Slide 25:
Test #1 Key vs. ordered retrieval High Cardinality
|
|
 |
| Slide 26:
Observations
|
|
 |
| Slide 27:
Test #2 Key vs. ordered retrieval<span style="mso-spacerun:
yes"> </span>Low Cardinality
|
|
 |
| Slide 28:
More Observations
|
|
 |
| Slide 29:
Test #3 - Key vs. ordered update New value
|
|
 |
| Slide 30:
Who Wins this one?
|
|
 |
| Slide 31:
Space Requirements
|
|
 |
| Slide 32:
What about Date fields?
|
|
 |
| Slide 33:
What about invisible fields?
|
|
 |
| Slide 34:
What about multiply occurring KEY fields?
|
|
 |
| Slide 35:
Ok - How to go about the conversion
|
|
 |
| Slide 36:
Or Just modify DDL and estimate space
|
|
 |
| Slide 37:
Or Even!
|
|
 |
| Slide 38:
Reorg Issues
|
|
 |
| Slide 39:
Reorg Issues - Cont.
|
|
 |
| Slide 40:
UAI OINDEX
|
|
 |
| Slide 41:
Reorg OI
|
|
 |
| Slide 42:
Questions?
|
|
