Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
