Archives of the TeradataForum

Message Posted: Tue, 03 Jul 2007 @ 09:05:40 GMT

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

<-- Anonymously Posted: Monday, July 02, 2007 23:47 -->

My humble $0.02

I remember having encountered such a problem before.

We had a query like

     del from table
     where 

we took a random integer (not null) column of the table (col1) and did the below

     Del from table
     Where 
     Substr(col1,9,1)='0';

     Del from table
     Where 
     Substr(col1,9,1)='1';

     Del from table
     Where 
     Substr(col1,9,1)='9;

and we were able to obivate the problem of running out of space.

However, the thing we didnt try was doing an MSR. I dont know whether it would have helped at all becuase although the queries running together may need arithmetically the same space, the distributions per amp may have been different. Just surmising though :). Request the gurus to please enlighten

Regards

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