[
https://issues.apache.org/jira/browse/DRILL-3929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006219#comment-15006219
]
Aman Sinha commented on DRILL-3929:
-----------------------------------
Sorry I could not respond sooner .. I was caught up with few other Drill
issues. [~julianhyde], I am afraid I would have to disagree; Index selection
is part of physical database design and is a core step in access path selection
which occurs at physical planning stage. Are you suggesting that relational
database systems are wrong in doing that ?
While some indexes could be modeled as MVs, I don't see how all indexes can be
modeled as such. Indexes have different physical implementations too: hash
index will *not* have collation whereas a clustered index will. So how can N
different physical implementations be modeled through logical planning ?
> Support the ability to query database tables using external indices
> ------------------------------------------------------------------------------
>
> Key: DRILL-3929
> URL: https://issues.apache.org/jira/browse/DRILL-3929
> Project: Apache Drill
> Issue Type: New Feature
> Components: Execution - Relational Operators, Query Planning &
> Optimization
> Reporter: Aman Sinha
> Assignee: Aman Sinha
>
> This is a placeholder for adding support in Drill to query database tables
> using external indices. I will add more details about the use case and a
> preliminary design proposal.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
