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.
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.