When to drop and recreate Join Indexes.

[lmarty1359]

There is much confusion about when join indexes should be dropped and recreated. What is the established norm for join index maintenance?

[visakhcr]

check this..hope it clears all your doubts about join indexes..

http://teradata.uark.edu/research/wang/indexes.html

[lmarty1359]

Thanks!! Another question, does it buy me anything to include "rowid" in the join index?