Re: Function Based Index
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Sep 2012 10:29:03 +0100
Purav,
No - when you create the index (and "compute statistics" is redundant in
10g, by the way) Oracle doesn't collect stats on the table column.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
----- Original Message -----
From: "Purav Chovatia" <puravc@xxxxxxxxx>
To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, September 17, 2012 3:35 PM
Subject: Re: Function Based Index
| That is exactly what I thought. But I remember having created the index
| with the 'compute statistics' clause. And in 10g, because statistics are
| automatically gathered for the hidden column too, I believe that
statistics
| would have been correctly present for the hidden column. But I will test
| and revalidate this understanding.
|
| Thanks.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
