Question

Explain sparse index and explain.

Answer 1

Answer

In sparse index, index records are not created for every search key. An index record here contains a search key and an actual pointer to the data on the disk. To search a record, we first proceed by index record and reach at the actual location of the data.

Answer 2

HOLA MATE

THIS IS YOIR ANSWER.

SPARSE INDEXES ONLY CONTAIN ENTRIES FOR DOCUMENTS THAT HAVE THE INDEXED FIELD, EVEN IF THE INDEX FIELD CONTAINS A NULL VALUE.

THE INDEX SKIPS OVER ANY DOCUMENT THAT IS MISSI G THE INDEXED FIELD. THE INDEX IS "SPARSE" BECAUSE IT DOES NOT INCLUDE ALL DOCUMENTS OF A COLLECTION.

I HOPE YOU LIKE MY ANSWER.

HAVE A GOOD DAY♥♥

THANKS..... $$$