vk82 wrote:NEVER unless you have proof that measurable benefit will result.
Sorry to ask the saem question again.
I know that most of the post are written on net for the same problem.
After google and going through Tom Kyte's Website I am still in confusion that when to rebuild the index. He said on his website that there is no requirement to rebuild index but i want to know in which circumstances i need to rebuild the indexes.
Can anyone help me out please.
Thanks in advance
vlethakula wrote:And what would you do when you would find that after the rebuild , the size of the index becomes larger?
I normally do when index size is greater than table size