Performance on load table from SQL Server

[#1]

Hi,

I suppose to load all rows from SQLServer table, It's supposed to be ~5 Million Rows.

In the table there are 20 columns, and i need to pull 10 of them.

In a matter only of traffic, and  overload on the system what is the efficient way to load:

Load* or load field1,Field2....

Thanks,

Jacob

[tresesco]

With WHERE you reduce the number of rows(records) while using Load/Select Field1, Filed2 ....Field10       you reduce number of fields(attributes). Hope it helps.

[#3]

I know it's reduce number of rows.. the question is about the DB is there a load difference between two approaches on his side..

[rbecher]

It depends. Usually a where clause reduces processing time on a database. This can lead into faster query results if you have an index on the column..

[ashfaq_haseeb]

Hi,

I would prefer you to use proper Index on the table to give you better performance.

Regards

ASHFAQ