Could you comment if this query could be further optimized? I have attached the Execution Plan at the end
--------------------------
-------
SELECT count(*)
FROM (select AA.Col1,G.Code,E.Col2,C.Co
l3 from AA, BB, CC where AA.AAKEY1 = BB.BBKEY1 and BB.KEY2 = CC.KEY2) A
INNER JOIN B ON
A.Key1 = B.Key1 --4654
--------------------------
--
INNER JOIN C ON
B.Key2 = C.Key2 --1798230
--------------------------
--
INNER JOIN D ON
C.Key3 = D.Key3 --1798230
--------------------------
--
INNER JOIN E ON
D.Key6 = E.Key6 --1798230
--------------------------
--
INNER JOIN F ON
D.Key6 = F.Key6 --1798230
--------------------------
--
INNER JOIN G ON
D.Key7 = G.Key7 --1885478
--------------------------
--
INNER JOIN H ON
G.Key8 = H.Key8 --1885478
--------------------------
--
WHERE
(H.Code = 'ABC') --128584
--------------------------
--
Table 'C'. Scan count 1, logical reads 16064, physical reads 0, read-ahead reads 16093.
Table 'D'. Scan count 1, logical reads 964, physical reads 0, read-ahead reads 0.
Table 'G'. Scan count 1, logical reads 387, physical reads 0, read-ahead reads 0.
Table 'H'. Scan count 1, logical reads 10, physical reads 0, read-ahead reads 0.
Table 'F'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0.
Table 'E'. Scan count 1, logical reads 7, physical reads 0, read-ahead reads 0.
Table 'B'. Scan count 1, logical reads 1481, physical reads 0, read-ahead reads 0.
Table 'AA'. Scan count 1, logical reads 35, physical reads 0, read-ahead reads 0.
Table 'BB'. Scan count 1, logical reads 216, physical reads 0, read-ahead reads 0.
Table 'CC'. Scan count 1, logical reads 1, physical reads 1, read-ahead reads 0.
