Speeding Up a Single-Key Lookup on a Large Orders Table - xha OA Question | OAHelper
Company: xha
Difficulty: medium
Problem Statement
Speeding Up a Single-Key Lookup on a Large Orders Table A query takes 45 seconds on a 100-million-row table: SELECT * FROM Orders WHERE CustomerID = 12345; Which action is most likely to reduce runtime?