asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Taewoo Kim <wangs...@gmail.com>
Subject Index-only plan has been merged.
Date Fri, 16 Feb 2018 19:11:51 GMT
Hi All,

Finally, the index-only plan branch has been merged. Thanks to all who have
reviewed this patch set. Here are a few things that I would like to post.

- The Index-only plan will be triggered on a B+ tree or an R tree (point or
rectangle field only) index. The field should be a closed-type field. A
field cannot be an open-type field.

- Only the secondary key and/or the primary key are used in a selection or
join predicate. Also, only those fields (SK or PK) are used afterward
(e.g., returning only those fields).

- If you see an error and see "UNION_ALL" operator and two paths in the
plan, it might be related to the index-only plan. For this case, before a
query, you can put " set noindexonly 'true'; " to bypass the index-only
plan as a temporary measure. Of course, please file an issue. :-)

Best,
Taewoo

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message