RE: indexing
From: <Jay.Miller_at_tdameritrade.com>
Date: Wed, 20 Feb 2013 20:24:32 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F72647A7D6_at_PRDTXWPEMLMB32.prod-am.ameritrade.com>
They finally fix that in 11.2? Thank you for the update, I still remember discovering that gotcha back when the feature was first introduced and I was (for a short time) ecstatic over it.
Date: Wed, 20 Feb 2013 20:24:32 +0000
Message-ID: <0D8F4CAC0F9D3C4AACC63F50FD9957F72647A7D6_at_PRDTXWPEMLMB32.prod-am.ameritrade.com>
They finally fix that in 11.2? Thank you for the update, I still remember discovering that gotcha back when the feature was first introduced and I was (for a short time) ecstatic over it.
Jay Miller
Sr. Oracle Database Administrator
201.369.8355
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
Sent: Wednesday, February 20, 2013 9:33 AM
To: oracle-l List
Cc: Brian Zelli
Subject: Re: indexing
There is another little known problem with index monitoring. Until 11.2 just gathering statistics on an index counted as "usage".
On 2013-02-19, at 12:32 PM, Wolfgang Breitling wrote:
> A word of caution: index usage monitoring is not foolproof.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 20 2013 - 21:24:32 CET