Search

OakieTags

more tags

Who's online

There are currently 1 user and 31 guests online.

Online users

Recent comments

Affiliations

Home

Extended statistics and function-based indexes

Submitted by Timur Akhmadeev on Thu, 2010-05-27 21:37

About a year ago I’ve discovered nice feature of Oracle 10gR2 CBO: to overcome an issue with calculated selectivity for predicates on multiple columns, it can use DISTINCT_KEYS of the available index. Couple of weeks ago the bug fix mentioned in the OTN thread actually helped to solve a performance issue of a query. And [...]