Re: Index strategy
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Thu, 3 Jun 2010 12:08:54 -0700 (PDT)
Message-ID: <de8a8bae-48c2-48d6-9db7-8a50e775e8f2_at_c10g2000yqi.googlegroups.com>
Mark:
Date: Thu, 3 Jun 2010 12:08:54 -0700 (PDT)
Message-ID: <de8a8bae-48c2-48d6-9db7-8a50e775e8f2_at_c10g2000yqi.googlegroups.com>
Mark:
# Monitoring is on by default in 10g so I would look for indexes that do not appear to be used and potentially drop those to free up space and eliminate the need to maintain them.
I think this is ( perhaps fairly widely ) mis understood. Monitoring of statistics for tables and indexes is on by default afaik. The usage monitoring needs to be turned on and off explicitly I believe. Received on Thu Jun 03 2010 - 14:08:54 CDT