Houri Oracle Partitioned Index Efficiency PartitionedIndexEfficiency Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist... 09 February 2017 10 min read
Houri Oracle Data Type Implicit Conversion Hierarchy In Oracle, under certain circumstances, an implicit data type conversion precludes the use of indexes. Perhaps you have a vague... 09 January 2017 10 min read
Houri 12c Hybrid histogram In the previous article about the Oracle 12c TOP-Frequency histogram, we saw that Oracle carries out a preliminary determination step... 26 January 2016 20 min read
Houri 12c Histogram: TOP-Frequency As of Oracle version 12.1, if a number of buckets N in a histogram is less than the number of... 19 January 2016 13 min read
Houri Index design: discard and sort Designing an index is not done through “trial and error”. This kind of strategy seems to doom many engineered indexes... 10 October 2014 17 min read
Houri SPM Plan: non reproducibility circumstances and CBO interaction 1. Introduction When a critical report which used to complete very quickly starts performing poorly, there is a big chance... 01 May 2014 17 min read
