这条SQL语句怎样写速度最快？

[sheng9hhd]

Select Column1,Column2,Column3 From (Select Column1,Column2,Column3,Column4 From Table1 Where Column1 is not NULL) a Where Cast(Column2 as datetime)>getdate()-1 Order by Column4,Column1 Desc