There was an Internal Forum and the question raised was “is there any optimizer hint that causes the optimizer to ignore histogram information ?” The question seemed to be interesting and thought of posting my reply to the question. CARDINALITY hint is the one that directs the Optimizer to take the value of the Number [...]