RE: Create View

Toooooo many question marks.

Our target is having a very fast and efficient access during the processing of 
the SELECT a,b,c,d
FROM x,y,z WHERE ...

So I wrote a program which create (from the DS) a PF for each type of record 
whit the same key of
the main PF

A trigger on the main PF (or a journal parser if too heavy) that sync the files

SQL target the PF's and since the data definition are copied from the DS there 
are no casting
problems, only, since the trigger has to use a program described file, the key 
definition for each
pf is not accurate (always 25 char) having some trailing blanks. But this is 
not altering the join
between tables  (right?).

Thanks
Marco

--- vhamberg@xxxxxxxxxxx wrote:

> Marco
> 
> Each LF adds some overhead - first of all is the space it takes. And then 
> there is the time to
> maintain an index, if the LF has one. 
> 
> Now I'm going to toss in another unknown - are the SST keywords processed as 
> each record is
> added, or are they run when the record is retrieved? If the former, are the 
> values stored in
> memory, possibly increasing the size of the LF?
> 
> HTH
> Vern
> 



                
__________________________________ 
Yahoo! Mail for Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail