无法测试查询但需要WHERE OR .. OR .. OR子句的最佳索引策略

An application runs a routine once a week. The last run was extremely slow and we know that more data will be processed during the next run. The slowest statement in the routine, by far, joins a temp table to a products table. Profiler shows a very high number of reads, suggesting it is not indexed well. During the last run, the Products table had 200,000 rows and the temp table had 1200.An application runs a routine once a week. The