6 Lab – Indexing for Joins

Now, it’s your turn: take the below queries individually and design the right nonclustered indexes to make them dramatically faster. You’re going to be joining between the small Users table and a few larger tables, so if you haven’t created indexes on the larger tables before, be aware that index creation will take longer depending…