Archives of the TeradataForum
Message Posted: Fri, 07 Mar 2003 @ 09:33:51 GMT
Chuck McDevitt wrote:
But it also affects how statistics are stored.
ct foo(col1 char(20), col2 int);
Within statistics there's only a maximum of 16 bytes of data stored:
--> First 16 bytes of col1, no data for col2
ct foo(col1 int, col2 char(20));
--> col1, First 12 bytes of col2
IMHO this one is better for the optimizer, because there's more info.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|