In case of one large table and 2 small tables, for an optimized query performance
A - The largest one should be cached to memory and small ones should be streamed
B - The small Ones should be cached and large one should be streamed
C - All of the table should be cached
D - All the tables should be streamed.