In this scenario it would make sense to create a clustered index that contains those two fields, something like the following. The indexes on the dedicated SQL table can be seen in SSMS, as illustrated in Figure 10.8. For more

Continue ReadingTune Queries by Using Indexers – Troubleshoot Data Storage Processing-3