Start : 0.00 seconds
SELECT artistName FROM Music_Artist A WHERE btActive = 1 ORDER BY artistName ASC

A : 0.01 seconds
Select TRIM(REPLACE(ArtistName,'The ','')) alteredArtistName, Max(FK_Genre), Max(ArtistName) artistName, Count(PK_Music_Video) videoCnt, max(Thumbnail_medium) as thumbNail, max(artistPopularity) , max(dtRecorded) from Music_Artist A LEFT JOIN Music_Video V on V.FK_Music_Artist=A.PK_Music_Artist where btLive=1 and (btVideo=1 OR btVideo is null) group by PK_Music_Artist order by artistName ASC

B : 2.18 seconds
Select TRIM(REPLACE(ArtistName,'The ','')) alteredArtistName, Max(FK_Genre), Max(ArtistName) artistName, Count(PK_Music_Video) videoCnt, max(Thumbnail_medium) as thumbNail, max(artistPopularity) , max(dtRecorded) from Music_Artist A LEFT JOIN Music_Video V on V.FK_Music_Artist=A.PK_Music_Artist where btLive=1 and (btVideo=1 OR btVideo is null) group by PK_Music_Artist order by alteredArtistName ASC, artistName ASC LIMIT 0,1000

D : 3.72 seconds