But i can see lot of logical reads and read-ahead reads here for the PDSPrioritizedPriceListItem table.
How can we reduce this to minimum. Any index suggestion to specially for this table.
Table 'PDSPrioritizedPriceListItem'. Scan count 1, logical reads 1399767, physical reads 0, read-ahead reads 871343, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 83812 ms, elapsed time = 89501 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.