Report question

Question: What's your approach for optimizing large tables (+1M rows) on SQL Server?