Data Warehousing Community Forum
October 24, 2019, 01:19:00 am

Pages: [1]   Go Down
Author Topic: Need clariifcation on Row ID in Teradata  (Read 17376 times)
DW Fresher

Reputation: +1/-0
Offline Offline

Posts: 5

View Profile
« on: November 16, 2013, 11:46:47 pm »

HI All,

In Teradata tables, when the row insert into a table , the AMP stores the Row ID in-front of each on it's disk.

Does this ROW ID consumes storage of disk, If so is that be one of the challenge in Teradata?

Could you please explain?
DW Fresher

Reputation: +0/-0
Offline Offline

Posts: 2

View Profile WWW
« Reply #1 on: November 18, 2016, 04:06:29 pm »

I also found that there is a difference on the identity column manipulation.... Thought we specified the start and end value along with increment count, it behaves differently. When we do Insert Into Values, it starts with 1 and incremented by 1 whereas when we do Insert Into ...Select, it starts with some 1000 or 10000 and incremented based on the increment value specified... don't know if there is any other dbc level setting for that.     
Tableau Training  |  Devops Training in Chennai  |  Informatica Training in Chennai Hadoop Training in ChennaiR Programming Training in Chennai

h  |   h  |   h  |   h  |   h
Pages: [1]   Go Up
Jump to: