Hi,
I am working on the CBO-based memory manager,
Overall, the idea is to based on stats provided by CBO(Cost based
Optimizer) to assign better memory to memory Intensive operators(JOIN,
ORDER, WINDOW, GROUP BY), instead of using the memory defined cc.conf.
Now, with that there are some design choices I need to make. So do let me
know the opinions or any improvement or any case I am missing and plus I am
not sure about the last case(underlined one).
*| Which Memory to Use? |
Query does NOT contain `compiler.operatormemory` | Query contains
`compiler.operatormemory` *|
|-------------------------------------------------------------------------|------------------------------------------------------------------------------|------------------------------------------------------------------|
| `compiler.cbo` is false OR `compiler.cbo` is true, |
|
|
| but stats are NOT available |
Use the memory defined in `cc.conf` | Use
the memory defined by the user in the query |
|-------------------------------------------------------------------------|------------------------------------------------------------------------------|------------------------------------------------------------------|
| `compiler.cbo` is true, and stats are available | Use
memory based on CBO Stats |* What
option to choose? Use CBO-based memory |*
| *OR User-defined memory?*
|
Thanks,
Gaurav
