Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


When to avoid secondary indexes?



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

Post New Answer

More Apache Cassandra Interview Questions

How does cassandra perform write operations?

1 Answers  


What are snapshots and how do you create one in cassandra?

1 Answers  


Explain how cassandra delete data?

1 Answers  


Define the term Column Families?

1 Answers  


What is the use of cassandra and why to use cassandra?

1 Answers  


Establish the difference between a node, cluster & data centres in Cassandra.

1 Answers  


What is a Seed Node in Cassandra ?

1 Answers  


Explain what is composite type in cassandra?

1 Answers  


What is the Internal Architecture of the Cassandra Database ?

1 Answers  


How Cassandra stores data?

1 Answers  


Which command is used to start the cqlsh prompt?

1 Answers  


What is the use of coordinator node in read?

1 Answers  


Categories