JOIN INDEXES WITH PRIMARY INDEX

Database

JOIN INDEXES WITH PRIMARY INDEX

Hello All,

Why we cannot have JOIN INDEXES with UPI/USI. If there is a option to create a Join Indexes with UPI/USI, how can it be done.

Thanks

Jugal

2 REPLIES
N/A

Re: JOIN INDEXES WITH PRIMARY INDEX

There is an option to have a join index with UPI :)

Teradata Employee

Re: JOIN INDEXES WITH PRIMARY INDEX

Hello Jugal,

You can create Join Index with UPI/NUPI. The only restriction in terms of Indexes is the inability to create USI on JI Columns. All these details available in the Database Design PDF.

Thanks,

Smarak