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
Yes, you can, but this could perform better
Load * ;
Sql select fields from tablename Where Condition;
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?
Better do optimized load, speed will increase.
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.
I have used where condition in sql statement too. Actually i used this statement its taking more time to load
using where at SQL clause is taking more time?
Are you familiar with Execution Plans? Could you post it here?
Retrieving data ...