Breaking two myths about rebuilding indexes in the Oracle Database

You’ll read over and over that B-tree indexes will perform fine even as rows are deleted from them. I agree that in theory this makes sense, and the vast majority of the time this holds true. In reality though, I have had to deal with severe performance issues where rebuilding indexes fixed things. Continue reading…

Advertisements

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