manticoresearch icon indicating copy to clipboard operation
manticoresearch copied to clipboard

Cost based optimizer improvements

Open sanikolaev opened this issue 3 years ago • 0 comments

Manticore Search has a cost based optimizer, but it's not perfect. Now that Manticore Search has:

  • secondary indexes
  • columnar storage
  • mix mode (part of the fields are columnar, others are row-wise)
  • .spt used for efficient lookup by id

it makes sense to improve the optimizer so it chooses the right path in most cases.

sanikolaev avatar Jul 27 '22 03:07 sanikolaev