[
https://issues.apache.org/jira/browse/CASSANDRA-6477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14503870#comment-14503870
]
Jonathan Ellis commented on CASSANDRA-6477:
-------------------------------------------
One advantage to MV is that people are somewhat more used to the MV lagging the
underlying data. PG goes so far as requiring you to manually issue refresh
commands. I think that makes them unusable, so I only mention that to
illustrate an extreme -- with that precedent, having us say "MV are eventually
consistent" sounds quite reasonable!
(Oracle has had self-updating MV forever. I'm not actually sure what kind of
transactionality guarantees you get there.)
> Global indexes
> --------------
>
> Key: CASSANDRA-6477
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6477
> Project: Cassandra
> Issue Type: New Feature
> Components: API, Core
> Reporter: Jonathan Ellis
> Assignee: Carl Yeksigian
> Labels: cql
> Fix For: 3.0
>
>
> Local indexes are suitable for low-cardinality data, where spreading the
> index across the cluster is a Good Thing. However, for high-cardinality
> data, local indexes require querying most nodes in the cluster even if only a
> handful of rows is returned.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
