Answer Posted / Vandana Kumari
Index covering occurs when an index contains all the columns needed to fulfill a database query, thus avoiding the need to access the underlying table. This can improve performance by reducing the amount of data that needs to be read from disk.nMerits:n- Faster query executionn- Reduced I/O operationsn- Improved concurrency
| 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
