Urgent : join between primary index and secondary index

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.

Urgent : join between primary index and...

Rate Topic

Display Mode

Topic Options

Author

Message

Siree

Posted 8/7/2008 2:12:24 PM

Junior Member

Group: Forum Members
Last Login: 9/30/2008 11:40:31 AM
Posts: 17, Visits: 48

Post #12475

Siree

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

Junior Member

Group: Forum Members
Last Login: 9/30/2008 11:40:31 AM
Posts: 17, Visits: 48

What are the pros and cons if we join between primary index and secondary index

Example:-

Table_1
Primary index( t1,t2)
Secondary index ( t3,t4,t5,t6)

Table_2
Primary index(t1,t2)

Join
Table_1.t4 = Table_2.t1
And
Table_1.t5= Table_2.t2

Is it good recommending to created secondary index , If join column is not part of Primary Index, Is there any issues ?

What are the recommendations for joining primary index column with non primacy index column ?

Post #12478

Siree

Posted 8/20/2008 1:04:34 PM

Junior Member

Group: Forum Members
Last Login: 9/30/2008 11:40:31 AM
Posts: 17, Visits: 48

Post #12664

« 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 3:07am