Indexing Only Some Rows- Basically a function-based index
- Most useful if we only want to index a certain (usually very small) set of rows
For example: create index foo_idx on my_table (case bar when 1 then 1 end);create index test_idx on test (decode(priority, 1, 'Y', 2,
'Y', null));
Reference: - "Expert Oracle Database Architecture", Tom Kyte, Apress, Chapter 11 (p. 470)
|
|