Oracle Scratchpad

September 19, 2010

Index degeneration

Filed under: Indexing,Performance,Troubleshooting,Tuning — Jonathan Lewis @ 11:12 am BST 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.

2 Comments »

  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 BST 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 BST Sep 19,2010 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Theme: Rubric. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 4,089 other followers