Hi,
I know explain statement results are relatively easy to understand but is there a comprehensive guide for it? 0: jdbc:phoenix:localhost> explain select count(1) from test.table where insert_ts > now() - 30; *+------------------------------------------+* *| ** PLAN ** |* *+------------------------------------------+* *| *CLIENT 1-CHUNK PARALLEL 1-WAY RANGE SCAN OVER TEST.TABLE [0,'2016-08-27 06:27:17.719'] - [0,*]* |* *| * SERVER FILTER BY FIRST KEY ONLY * |* *| * SERVER AGGREGATE INTO SINGLE ROW * |* *+------------------------------------------+ * Like for example in the query above from what I understand, it fetches everything from the server then applies the key range on client side. But I’m thinking isn’t it less expensive if key range was already applied on the server so less data will be transmitted, thus saving network and memory overhead. Or is my understanding wrong? Thanks
