All Forums Database
26 Nov 2014
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

agnitc 9 posts Joined 11/14
30 Nov 2014

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

SmarakDas 51 posts Joined 02/12
30 Nov 2014

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

You must sign in to leave a comment.