Hi Nantia, that's a good question - if your input data is very small, there is nothing to worry about. For the explain output, the memory estimates are rounded to MB. Therefore, whenever your input is less than 65,536 cells (dense), you will see a memory estimate of 0 MB (e.g., round(65,535*8/(1,024*1,024)) = 0).
Regards, Matthias On Mon, Sep 4, 2017 at 2:24 AM, Nantia Makrynioti <[email protected]> wrote: > Hello, > > I generated a HOP plan and memory estimates for the input data of HOP > operators are all 0MB. The code runs locally and the execution type is CP. > What could be the case where memory is estimated to 0MB? > > Thank you very much, > Nantia >
