Your developer have created a highly normalized schema that requires complex queries with many join operations to retrieve data.What information will you use to determine an optimum value for --join-buffer-size?

A、thesizeofthelongestrowinanytablethatparticipatorsinajoinquery
B、thetotalsizeofalltablesinyourmostcomplexjoinquery
C、thesizeofthelargesttableinanyJOINquery
D、thesizeofthesmallesttableinanyjoinquery
E、thetotalsizeofthetwosmallesttablesinanyjoinquery
F、theaveragessizeofanyrowthatparticipatesinajoinqueryG:thetotalsizeofthetwolargesttablesinanyjoinquery