Archives of the TeradataForum

Message Posted: Thu, 09 Sep 2004 @ 15:03:46 GMT

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

What is the configuration (SMP, MPP, W2K, MP-RAS)? Is there skewing on the NUPI columns? (when you run a query like "select branch_id,customer_no,count(*) from "each table" group by 1,2 having count(*) GT 1 order by 3 desc" do you get rows returned for each table?

What is the explain? What Tdat R? (4,5,5.1)?

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