SQL Server — Indexes & plans

1 MySQL SELECT with LIMIT Easy 2 T-SQL nonclustered index #1 Hard 3 T-SQL nonclustered index #2 Medium 4 T-SQL nonclustered index #3 Easy 5 T-SQL nonclustered index #4 Medium 6 T-SQL nonclustered index #5 Hard 7 T-SQL nonclustered index #6 Medium 8 T-SQL nonclustered index #7 Easy 9 T-SQL nonclustered index #8 Medium 10 T-SQL nonclustered index #9 Hard 11 T-SQL nonclustered index #10 Medium 12 T-SQL nonclustered index #11 Easy 13 T-SQL nonclustered index #12 Medium 14 T-SQL nonclustered index #13 Hard 15 T-SQL nonclustered index #14 Medium 16 T-SQL nonclustered index #15 Easy 17 T-SQL nonclustered index #16 Medium 18 T-SQL nonclustered index #17 Hard 19 T-SQL nonclustered index #18 Medium 20 T-SQL nonclustered index #19 Easy 21 T-SQL nonclustered index #20 Medium 22 T-SQL nonclustered index #21 Hard 23 T-SQL nonclustered index #22 Medium 24 T-SQL nonclustered index #23 Easy 25 T-SQL nonclustered index #24 Medium 26 T-SQL nonclustered index #25 Hard 27 T-SQL nonclustered index #26 Medium 28 T-SQL nonclustered index #27 Easy 29 T-SQL nonclustered index #28 Medium 30 T-SQL nonclustered index #29 Hard 31 T-SQL nonclustered index #30 Medium 32 T-SQL nonclustered index #31 Easy 33 T-SQL nonclustered index #32 Medium 34 T-SQL nonclustered index #33 Hard 35 T-SQL nonclustered index #34 Medium 36 T-SQL nonclustered index #35 Easy 37 T-SQL nonclustered index #36 Medium 38 T-SQL nonclustered index #37 Hard 39 T-SQL nonclustered index #38 Medium 40 T-SQL nonclustered index #39 Easy 41 T-SQL nonclustered index #40 Medium 42 T-SQL nonclustered index #41 Hard 43 T-SQL nonclustered index #42 Medium 44 T-SQL nonclustered index #43 Easy 45 T-SQL nonclustered index #44 Medium 46 T-SQL nonclustered index #45 Hard 47 T-SQL nonclustered index #46 Medium 48 T-SQL nonclustered index #47 Easy 49 T-SQL nonclustered index #48 Medium 50 T-SQL nonclustered index #49 Hard