When to drop and recreate Join Indexes.

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

When to drop and recreate Join Indexes.

Rate Topic

Display Mode

Topic Options

Author

Message

lmarty1359

Posted 3/26/2008 12:45:36 PM

Forum Newbie

Group: Forum Members
Last Login: 5/7/2008 7:41:57 PM
Posts: 2, Visits: 14

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

Post #11048

bonchibuji

Posted 3/27/2008 8:21:24 AM

Junior Member

Group: Forum Members
Last Login: 6/9/2008 10:02:05 AM
Posts: 23, Visits: 82

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

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

bonchibuji

Post #11067

lmarty1359

Posted 5/7/2008 5:34:49 PM

Forum Newbie

Group: Forum Members
Last Login: 5/7/2008 7:41:57 PM
Posts: 2, Visits: 14

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

Post #11378

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:16pm