Archives of the TeradataForum

Message Posted: Fri, 07 Mar 2003 @ 09:33:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Chuck McDevitt wrote:

But it also affects how statistics are stored.

ct foo(col1 char(20), col2 int);
create Index bar(col1 char(20), col2 int) on foo;
collect statistics on foo index bar;

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));
create Index bar(col1 int, col2 char(20)) on foo;
collect statistics on foo index bar;

--> col1, First 12 bytes of col2

IMHO this one is better for the optimizer, because there's more info.

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>