When to drop and recreate Join Indexes.

Database

When to drop and recreate Join Indexes.

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

Re: When to drop and recreate Join Indexes.

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

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

Re: When to drop and recreate Join Indexes.

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