[
https://issues.apache.org/jira/browse/TAJO-838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14166126#comment-14166126
]
Mai Hai Thanh commented on TAJO-838:
------------------------------------
Hi Jihoon,
The preliminary test results look very impressive.
Could you share the amounts of time for index creation and maintenance ?
Whenever the table data is updated or appended (I guess, every few hours or
every day in a typical data warehouse), the index needs to be updated (or
re-created) to ensure the correctness of query results. So, it will be better
if we can get up-to-date indexes in a short time.
Besides, technically, do you pack the data inside the index ? (in other words,
will the index provide only pointers to the real data ?)
Thanks
> Improve query planner to utilize index
> --------------------------------------
>
> Key: TAJO-838
> URL: https://issues.apache.org/jira/browse/TAJO-838
> Project: Tajo
> Issue Type: Sub-task
> Components: planner/optimizer
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Priority: Minor
>
> Index can improve the query performance when the selectivity of query is high.
> Thus, query planner should decide whether index is used or not for a given
> query.
> The selectivity can be guessed using statistics.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
