Hi, I am trying to get the explain plan for below query.
explain select i.itemname,i.price,sum(o.quantity) from items as i join orders as o on i.itemid=o.itemid group by i.itemname,i.price; I get output as below +------------+ | PLAN | +------------+ | CLIENT PARALLEL 1-WAY FULL SCAN OVER ITEMS | | SERVER AGGREGATE INTO DISTINCT ROWS BY [I.ITEMNAME, I.PRICE] | | CLIENT MERGE SORT | | PARALLEL INNER-JOIN TABLE 0 | | CLIENT PARALLEL 1-WAY FULL SCAN OVER ORDER1 | | DYNAMIC SERVER FILTER BY ITEMID BETWEEN MIN/MAX OF (O.:ITEMID) | +------------+ Please anyone help me understand this explain plan, What is this CLIENT and SERVER, I am not able to figure out. Thanks and Regards, Komal Ravindra Thombare =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
