RE: Function-based indexes and trunc()

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 20 Apr 2014 11:09:58 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DE9FF3_at_exmbx05.thus.corp>

Well spotted.

I was looking for things to do with dates or truncates when I checked the fix controls and parameters and missed that one completely. (There's a lovely parameter including the word "datefold" that looked very promising but obviously turned out to be irrelevant.)

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: Velikikh Mikhail [mvelikikh_at_gmail.com] Sent: 20 April 2014 05:01
To: Jonathan Lewis
Cc: Mohamed Houri; oracle-l_at_freelists.org Subject: Re: Function-based indexes and trunc()

Hi,

Seems like this enhancement introduced in 11.2.0.2 with fix_control 9263333.

SQL> exec print_table( 'select * from v$system_fix_control where bugno=9263333')

BUGNO                         : 9263333
VALUE                         : 1
SQL_FEATURE                   : QKSFM_CBO_9263333
DESCRIPTION                   : generate transitive predicates for virtual column expressions
OPTIMIZER_FEATURE_ENABLE      : 11.2.0.2
EVENT                         : 0
IS_DEFAULT                    : 1
-----------------

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Apr 20 2014 - 13:09:58 CEST