Which one of them is fast to execute?

[ksandeep]

Hi,
Just had a query in my mind.
I have a table master_data with 16 columns.
so please tell me which one of the following would less time to execute.

1. select * from master_data;

2. select cust_name from master_data;

From the above example, i am interested to know, does number of parameters selected in the query effect the execution time.

Sandeep

 

[reclusivemonkey]

Give it a try and see? ;-)

You can even call it from VBA, getting the time with a debug.print, running the SQL, then getting the time again.