Start : 0.00 seconds
i is not equal to 0, 1 or 2SELECT artistName FROM Music_Artist A WHERE btActive = 1 ORDER BY artistName ASC
A : 0.01 seconds
select
TRIM(REPLACE ( ArtistName, 'The ', '' )) alteredArtistName,
Max(G.FK_Music_Genre ) FK_Music_Genre,
Max( ArtistName ) artistName,
Count( PK_Music_Video ) videoCnt,
max( Thumbnail_medium ) AS thumbNail,
max( artistPopularity ),
max( dtRecorded )
from Music_Link_Artist_Genre G
LEFT JOIN Music_Artist A on G.FK_Music_Artist = A.PK_Music_Artist
LEFT JOIN Music_Video V ON V.FK_Music_Artist = A.PK_Music_Artist
WHERE G.FK_Music_Genre=1 and A.btActive=1 group by PK_Music_Artist
order by A.artistName ASC
B : 3.80 seconds
select
TRIM(REPLACE ( ArtistName, 'The ', '' )) alteredArtistName,
Max(G.FK_Music_Genre ) FK_Music_Genre,
Max( ArtistName ) artistName,
Count( PK_Music_Video ) videoCnt,
max( Thumbnail_medium ) AS thumbNail,
max( artistPopularity ),
max( dtRecorded )
from Music_Link_Artist_Genre G
LEFT JOIN Music_Artist A on G.FK_Music_Artist = A.PK_Music_Artist
LEFT JOIN Music_Video V ON V.FK_Music_Artist = A.PK_Music_Artist
WHERE G.FK_Music_Genre=1 and A.btActive=1 group by PK_Music_Artist
order by A.artistName ASC
D : 7.80 seconds