Archives of the TeradataForum
Message Posted: Mon, 15 Mar 2004 @ 17:07:08 GMT
We're doing some compression and have been asked to verify that the data in a compressed table is the same as the data in an uncompressed table.
The simplest way I could see to do this was symmetric differences, like so:
LOCKING original FOR ACCESS LOCKING compressed FOR ACCESS SELECT * FROM original MINUS SELECT * FROM compressed
and then vice-versa. Since the tables have identical PIs, I expected to see entirely AMP-local activity, so this part of the explain plan puzzles me:
What sort of redistribution is involved in this? "None" would have been my answer before seeing the explain plan, and "None" is still my best guess.
Can someone tell me exactly what's going on with this?
All the best,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|