Speed of data retrival
From: Stjepan Brbot <stjepan.brbot_at_zg.hinet.hr>
Date: Tue, 28 May 2002 15:23:09 +0200
Message-ID: <ad00gm$c11b$2_at_as201.hinet.hr>
[Quoted] [Quoted] What is the difference according to speed of data retrival or any other [Quoted] aspect of execution speed if one uses more columns in SELECT SQL-statement?
Date: Tue, 28 May 2002 15:23:09 +0200
Message-ID: <ad00gm$c11b$2_at_as201.hinet.hr>
[Quoted] [Quoted] What is the difference according to speed of data retrival or any other [Quoted] aspect of execution speed if one uses more columns in SELECT SQL-statement?
Is there any difference in retrival of these two SELECT statements:
SELECT col1,col2,col3 FROM table1 WHERE col1=4
and
SELECT col1,col2 FROM table1 WHERE col1=4
-- Stjepan BrbotReceived on Tue May 28 2002 - 15:23:09 CEST