Oracle Scratchpad

September 19, 2010

Index degeneration

Filed under: Indexing,Performance,Troubleshooting,Tuning — Jonathan Lewis @ 11:12 am GMT Sep 19,2010

There’s a thread on OTN that talks about a particular deletion job taking increasing amounts of time each time it is run.

It looks like an example where some thought needs to go into index maintenance and I’ve contributed a few comments to the thread – so this is a lazy link so that I don’t have to repeat myself on the blog.


  1. Not related to the subject of your post – but it was a real fun to notice that your status on OTN is merely “expert” and not “ace” :)

    Comment by al0 — September 19, 2010 @ 11:29 am GMT Sep 19,2010 | Reply

    • al0,

      Technically I should have one of those “ACE Director” logo thingies – but no-one every got around to adding it.

      It doesn’t bother me, I’m really not interested in titles; the only important bit is that Oracle Corp. helps to pay for some of the trips I do to support user group events because of the ACED.

      Comment by Jonathan Lewis — September 19, 2010 @ 11:37 am GMT Sep 19,2010 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by