All Forums Database
Moutusi 38 posts Joined 03/13
26 Jul 2014
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?

Thanks, Moutusi
dnoeth 4628 posts Joined 11/04
27 Jul 2014

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_112A/ch10.060.16.html

Dieter

You must sign in to leave a comment.