When to avoid secondary indexes?
Answer / Satendra Kumar Yadav
Secondary indexes should be avoided when: the query selectivity is high - in this case, most of the data would need to be scanned even with an index; the write load is very high as secondary indexes can slow down writes due to their maintenance overhead; there are frequent updates or deletions on the indexed column.
| Is This Answer Correct ? | 0 Yes | 0 No |
How does cassandra perform write operations?
What are snapshots and how do you create one in cassandra?
Explain how cassandra delete data?
Define the term Column Families?
What is the use of cassandra and why to use cassandra?
Establish the difference between a node, cluster & data centres in Cassandra.
What is a Seed Node in Cassandra ?
Explain what is composite type in cassandra?
What is the Internal Architecture of the Cassandra Database ?
How Cassandra stores data?
Which command is used to start the cqlsh prompt?
What is the use of coordinator node in read?
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)