Load and sql select

[Anonymous]

     Hi all,

Can we write

Load * Where Condition ;

Sql select fields from tablename;

Will it increase the performance .i tried this but it is fectching records very slow

Thanks

[Clever_Anjos]

Yes, you can, but this could perform better

Load * ;

Sql select fields from tablename Where Condition;

[Anonymous]

Hi,

It's like loading all the data from SQL first and getting only what you require from preceding load. Why not apply the where condition on the SQL itself?

[#4]

Better do optimized load, speed will increase.

[Gysbert_Wassenaar]

Try adding the where condition to the sql statement. That way it won't load all the data from the source database, but only those matching the where clause.

[Anonymous]

Hi All,

I have used where condition in sql statement too. Actually i used this statement its taking more time to load

[Clever_Anjos]

using where at SQL clause is taking more time?

Are you familiar with Execution Plans? Could you post it here?