Table degeneration and amp data arrangement

Extensibility
Enthusiast

Table degeneration and amp data arrangement

Hi everyone,

How to check if table is degenerated or not?

- If so, than how to pix it or what tool should I use?

How to check are the data on amps/nodes arranged properly? (splited up equally?)

- If so, what tool shoudl I use to fix it?

Regards!

2 REPLIES
Senior Apprentice

Re: Table degeneration and amp data arrangement

What do you mean by "degeneration"?

To check for skewed distribution you'll find some queries in the forum, e.g.:

http://forums.teradata.com/forum/database/help-for-stats

Dieter

Enthusiast

Re: Table degeneration and amp data arrangement

I was thinking about sth like... when you backup some table and table ID's how to make the table not to overwhrite IDS and unixue data?

Or... when you archive the table, and table got missing records every 30klines than what to do to make it work faster. Defragment or sth?