Thursday, January 27, 2011

Can you create a table with no Primary Index in teradata?

NO. Its not possible.... if you dont mention external priamry index, teradata creates one for you

Teradata uses this Priamry index to distribute data among AMPs
Posted by at

1 comment:

  1. AnonymousJuly 8, 2011 at 12:31 PM

    Yes you can, see: http://developer.teradata.com/database/articles/say-yes-to-no-primary-index-no-pi-tables

    ReplyDelete

Subscribe to: Post Comments (Atom)