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


Reply via email to