 |
 |
Archives of the TeradataForum
Message Posted: Mon, 18 Mar 2008 @ 01:34:38 GMT
| Subj: | | Re: Creating a table with a 0 skew factor |
| |
| From: | | McCall, Glenn David |
| | Also have a look at the hash functions in the "Functions and Operators" manual. You can use these to see where the rows in your table are
going to. Example select hashamp( hashrow (pi_val1, pi_val_2)), pi_val1, pi_val2 from dummy_space_table; | |
Oops, my example should of course read:
select hashamp( hashbucket (hashrow (pi_val1, pi_val_2))), pi_val1,
pi_val2
from dummy_space_table;
But you would have seen that during your RTFM effort - wouldn't you!?!?!?
Glenn Mc
| |
