RE: CHAIN to a DS

[CWilt@xxxxxxxxxxxx]

> -----Original Message-----
> From: CarollaT@xxxxxxxxxxxxxx [mailto:CarollaT@xxxxxxxxxxxxxx]
> Sent: Friday, September 03, 2004 4:11 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: CHAIN to a DS
> 
> 
> [CWilt wrote]
> 
> How about:
>  
> 1) Not having to update anything!...
>  
> 
> [/]
> 
>  
> 
> Nope.  32 files max in SQL.  This is 60+ files (67 currently).  
> 
>  
> 
> But don't think I didn't consider that before even building these
> 'conglomeration' files.  
> 

Opps, didn't think about that.  <grin>


>  
> 
> Seriously though, how fast do you think a 67-file union SQL, 
> over files
> containing a total of around 30-40 million records, would 
> run?  This would
> involve summarization... 
> 
>  
> 

Well, I don't think it's going to be any worse than a single file with 67*40
million records.

Correct me if I'm wrong, but as I understand it, a view can make use of
indexes on the underlying tables.


Charles