SQL optimization OR

SQL Server analysis and compilation time: the CPU time is 187 milliseconds, and the Occupied time is 247 milliseconds. (4 rows affected) Worktable. Scan count 8, logical reads 823264, physical reads 0, pre-reads 0, lob logic reads 0, lob physical reads 0, and lob pre-reads 0. Table cb_Contract. Scan count 18,

SQL Server Analysis and Compilation Time: CPU time = 187 milliseconds, occupied time = 247 milliseconds. (4 rows affected) Table 'worktable '. Scan count 8, logical reads 823264, physical reads 0, pre-reads 0, lob logic reads 0, lob physical reads 0, and lob pre-reads 0. Table 'cb _ Contract '. Scan count 18,

SQL Server Analysis and Compilation Time: CPU time = 187 milliseconds, occupied time = 247 milliseconds. (4 rows affected) Table 'worktable '. Scan count 8, logical reads 823264, physical reads 0, pre-reads 0, lob logic reads 0, lob physical reads 0, and lob pre-reads 0. Table 'cb _ Contract '. The scan count is 18, the logic reads 15552, the physical reads 2, the website space, the pre-read 1738, the lob logic reads 0, the lob physical reads 0, and the lob pre-read 0. Table 'P _ provider '. The scan count is 16, the logic reads 548, the physical reads 2, the pre-read 111, the lob logic reads 0, the lob physical reads 0, and the lob pre-read 0. Table 'worktable '. Scan count 0, Hong Kong virtual host, logic read 0, physical read 0, pre-read 0, lob logic read 0, lob physical read 0, lob pre-read 0. SQL Server execution time: CPU time = 29717 milliseconds, U.S. space, occupied time = 8419 milliseconds. Warning null values are eliminated for aggregation or other SET operations. SQL Server Analysis and Compilation Time: CPU time = 0 ms, occupation time = 0 ms. SQL Server execution time: CPU time = 0 ms, occupied time = 0 ms.