Archives of the TeradataForum
Message Posted: Fri, 28 Jul 2006 @ 09:32:59 GMT
| Subj: | | Re: Oracle to Teradata Migration and Max Row Size |
| |
| From: | | Michael Larkins |
I have never heard that the maximum row size in Teradata is 64K. There is what is called an over-sized row - larger than 64K. The largest
column in a table is 64K and you could have two columns.
With that said, why in the world would you want a row that big? You only get one per block - talk about slow I/O. Are you doing it because
Oracle didn't want you to do joins in order to sometimes get that much data? Without knowing your requirements, it would seem normally better in
Teradata to go 3rd normal form and have multiple tables instead of incredibly inefficient row size like yours.
Just try to remember that Teradata is not Oracle - Praise God for that! If it was like Oracle you probably would not need to migrating away
from it now. You will be much happier if you don't bring your Oracle habits to Teradata. You might consider taking some classes or reading
books to learn good Teradata techniques.
Regards, Mike
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| 
