Loading data qvd optimized

[arsenal1983]

Hi,

I'm trying to load huge set of data from qvd files.

I would like to create qvd optimized import process but I need to filter data besed on 2 fields.

so I have:

TAB:

Load

     *

from

     XXX

where

     Exists(FIELD_1)

     or

     Exists(FIELD_2);

but this script is not optimized is there any chance to create optimized script with more than 1 where condition?

[arsenal1983]

It will not work - because this set of data sometimes are separable and sometimes not, for example:

if on my field_1 lis I will have 1 and if on my field_2 list I will have 2 then I will load ID 2 twice.

[Clever_Anjos]

TAB:

Load

     *

from  XXX

where

     Exists(FIELD_1);

concatenate

Load

     *

from    XXX

where

     Exists(FIELD_2) and not exists(FIELD_1);

[arsenal1983]

it will work but it will not be optimized load...

[marcus_sommer]

Are both fields depending to eachother in any way then you might be able to include this within the qvd-generation in an extra field. Are both fields instead completely independent to eachother then you will always need two conditions. But maybe there are further ideas from anyone if you provide some more details instead of the abstract FIELD_1/2.

- Marcus