2 Lab: Indexing for WHERE

Now, it’s your turn: in the Stack Overflow database (any size is fine, including the small 10GB one), take the below queries individually and design the right nonclustered indexes to make them dramatically faster. As you work through the list: Try different combinations of key and include fields for each query Use index hints to measure…