Saved Bookmarks
| 1. |
When Is It Preferable To Use A Dense Index Rather Than A Sparse Index? |
|
Answer» It is PREFERABLE to use a dense index instead of a sparse index when the file is not sorted on the indexed field (such as when the index is a SECONDARY index) or when the index file is SMALL compared to the SIZE of memory. It is preferable to use a dense index instead of a sparse index when the file is not sorted on the indexed field (such as when the index is a secondary index) or when the index file is small compared to the size of memory. |
|