Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

query speed

May 16, 2002, 5:54 AM
courierb
User (344 posts)
courierb's avatar
May 16, 2002, 5:54 AM
Views: 8092
Shortcut
Quote Reply
query speed
which one result the fast query speed?



SELECT * FROM Artist,CD WHERE (CD.ArtistID=Artist.ArtistID) AND Artist.ArtistID=22;



SELECT * FROM (Artist INNER JOIN CD ON CD.ArtistID=Artist.ArtistID) WHERE Artist.ArtistID=22;



Thanks
Subject Author Views Date
Thread query speed courierb 8092 May 16, 2002, 5:54 AM
Post Re: [courierb] query speed 		Paul 7849 May 16, 2002, 6:13 AM
Post Re: [courierb] query speed 		Stealth 7844 May 16, 2002, 9:42 AM
Thread Re: [courierb] query speed 		Alex 7887 May 16, 2002, 11:06 AM
Thread Re: [Alex] query speed 		Wil 7913 May 16, 2002, 12:22 PM
Thread Re: [Wil] query speed 		Paul 7936 May 16, 2002, 12:47 PM
Thread Re: [Paul] query speed 		Wil 7903 May 16, 2002, 12:54 PM
Post Re: [Wil] query speed 		courierb 7850 May 16, 2002, 4:02 PM