Top and sort kills this ?
select top 1000 CourseAssetId, CourseInitialId , CourseSize , [filename] from CourseAsset
where CourseID = 21 and Status = 'Published' and FolderId = 8765 and CreateDate < '2016-02-20 23:25:36.000' and
CourseAssetId not in (select CourseAssetId from CourseImage where CourseAssetId
is not null ) Order by CourseAssetSize desc
All indexes are in place . Is there a way to optimize this?