Use of ROWID within a Join Index

Database
Fan

Use of ROWID within a Join Index

The teradata docs state that ROWID is allowed within the creation of a join index. In what scenarios would this kind of implementation apply? I'm trying to understand why or how it would be used. Thank you.
1 REPLY
Junior Supporter

Re: Use of ROWID within a Join Index

The ROWID will link the join index rows to the base table rows (f. ex.: partial covering indexes).

HTH.

Cheers.

Carlos.