Four table, table A inner join behind three tables BCD, inner join table 3 C, data capacity is 1500 lines, and the fourth table D data volume 640 lines, is can't run out,

Code abbreviations are as follows:
Select count (1)
From A
Inner join B on a.R EQ_NO=b.R EQ_NO
Inner join on C b.B IZ_NO=c.l oan_no
Inner join D on c. ERCHANT_No=d.M ERCHANT_No

CodePudding user response:

The C and Djoin can find out the data

CodePudding user response:

C and D inner join is data,

CodePudding user response:

CodePudding user response:

Brother, can be found out, and the data it doesn't matter.

CodePudding user response:

The execution plan posted bai