I remembered sometime back a DBA has told me that one of his DBA colleague has rebuild all the indexes in a production database and mailed to their management and immediate boss stating that this is going (rebuilding indexes) to improve the database performance and also attached an URL which stated that rebuilding indexes will improve the database performance. I had told my friend to get me the answer for the following questions from his DBA colleague:
Does he know what is the harm or side effects of doing it?
Were there any performance issues in the database, if so, are they related to indexes?
What amount of performance improvements he measured or gained after?
I am yet to get answers for the above questions. And moving on to another incident...
I know a company very personally who follws(still following) so called 'database re-org' method to re-organize their database weekly. When I questioned them why they are doing it so, their answer is that they have gained an immediate performance improvements when they did it first time and they are following this procedure in order to not to drop the performance level. It was really difficult to convience them how dangerious it would to follow this method.
Myself would definitely will not go for 'leaven an arrow in the dark' policy/method. Even if I solve something accidently, I love to spend some time to do R&D to come to a conclusion.
Last but not least, when I visit a doctor, I do expect him to do analysis of my problem and try to cure it permanently rather than giving a pain killer to relief me temporarily from the pain.
I, therefore, invite you all to discuss your wired experiences or incidents that you come across.