Secondary Index and No PI table

Database
Enthusiast

Secondary Index and No PI table

SI in normal table creates subtables which holds SI value, SI Row ID and PI Row ID. When we create SI on NoPI or colunar table what will be stored in SI sub table?

1 REPLY
Junior Contributor

Re: Secondary Index and No PI table

There's no difference for a NUSI on PI vs. NoPI tables, each row in a NoPI table still has a RowID:

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Management/B035_1094_112...