Index Rebuild

Quote:

---

Originally posted by julian
This is an academical article having lost of assumptions (very right ones inedeed). I have the same views with him (we had an interesting talk last month) but hei: there is one non-mentioned good reason why to rebuild indexes: users very often create the indexes into the default tablespace which is a differenet mount point then the index one. At some point you have the data mount point 90% full and the index mount point only 20%.

---

Hey, I'm with you. However, there are lots of people out there that advocate having indexes and tables in the same tablespace.

We've played this one before - start with slimdave's post in http://www.dbasupport.com/forums/sho...ex+table+space

Quote:

---

Originally posted by DaPi
We've played this one before - start with slimdave's post in http://www.dbasupport.com/forums/sho...ex+table+space

---

So what :-) that's a nice topic, I like it :-)

Quote:

---

Originally posted by julian
So what :-) that's a nice topic, I like it :-)

---

Quite! There are many pleasurable activities worth repeating (daily at least!). Why not build on experience to increase the pleasure ;).

Quote:

---

Originally posted by julian
This is an academical article having lost of assumptions (very right ones inedeed)

---

I wouldn't say it's an academical article - I'd say its very unbiased and objective article. He doesn't simply say: "Don't rebuild indexes, it's stupid thing to do". He investigates both sides, pros and cons, and exposes both (potentially) good things that rebuilding can do for you as well as some quite dangerous sidefects of rebuilding.

Quote:

---

but hei: there is one non-mentioned good reason why to rebuild indexes: users very often create the indexes into the default tablespace which is a differenet mount point then the index one

---

I don't find this reason to be relevant one neither for this discussion nor as a comment to the mentioned article. Why? Because both the original question of this thread as well as the article discuses the habit of rebuilding indexes regularly (ie rebuilding the same indexes over and over again in (more or less) regular intervals)! Your case is a different one, it's one-time action in an index's liftime. So totally different subject.

The only case where regular rebuild seems to be a good idea is in a "rightwards migrating" index, where you add high-values and delete low-values of the indexed column from the base table.

However, this is a case where a regular index should probably be avoided in favour of a "reverse" index, which would not only remove the rebuild requirement but also the potential for serialization problems in index modification operations.

Quote:

---

Originally posted by jmodic
I wouldn't say it's an academical article - I'd say its very unbiased and objective article. He doesn't simply say: "Don't rebuild indexes, it's stupid thing to do". He investigates both sides, pros and cons, and exposes both (potentially) good things that rebuilding can do for you as well as some quite dangerous sidefects of rebuilding.


I don't find this reason to be relevant one neither for this discussion nor as a comment to the mentioned article. Why? Because both the original question of this thread as well as the article discuses the habit of rebuilding indexes regularly (ie rebuilding the same indexes over and over again in (more or less) regular intervals)! Your case is a different one, it's one-time action in an index's liftime. So totally different subject.

---

That's another one of your fuzzy answers. I don't agree with your kind of arguments. You seem to like to argue too much :-)

Huh? Arguing? Huh?

So you don't agree that your "non-mentioned good reason" is totaly nonrelated to the original question of this thread? And that it is in no way related to the topic covered in JL's article?

Well, I guess I (we) will not get your ansnwer to this coz you dont like "arguing" :rolleyes:

I like arguing.

Quote:

---

Originally posted by slimdave
I like arguing.

---

... just ask my wife (ba dum dum)!