Query vs Table

Article View: borland.public.cppbuilder.database.ado

Article #1046

Back to borland.public.cppbuilder.database.ado Previous Next

#1046

From: Daniele Borini
Date: Wed, 10 Nov 2004 09:30

12 lines
1199 bytes

Hi all,
i need to retrieve some values from a table by a certain value of the id 
field.
SQL statement is something kinda:
SELECT orderNo,date FROM Orders WHERE idCostumer=10

i should use a Query, but i should use a table too, by specifing this 
filter: idCostumer=10.

the result is the same, but, which's the faster?

10x Daniele

Technical Details

Message-ID: <4191dfa3@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,3e210ae96ce64799,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 10 Nov 2004 10:30:14 +0100
From: Daniele Borini <borini@infinito.it>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Query vs Table
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 80.180.24.156
Message-ID: <4191dfa3@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1100079011 80.180.24.156 (10 Nov 2004 01:30:11 -0700)
Lines: 12
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail