Geek Answers Handbook

What exactly does “fix” in relation to the indexes in the DBMS?

As part of the test question, students were asked to identify and describe linking to indices. When someone talks about being “fixed” in indices, what is it? Is there any other word / term that I can find since Google has not provided any solutions.

+7
source share
2 answers

When a table or index is pinned, it means that it is stored in memory.

The database has a certain amount of memory for which it is available. Typically, a database caches recently used data.

When an index is pinned, it means that the index is stored in memory permanently, rather than leaving the cache.

+5
source

Fixing something in a DBMS means that a thing is always stored in memory.

It is often used for hot indexes, which see a lot of queries against them, but can exit the database cache and load from disk. By keeping the index in memory, index scanning theoretically will never require disk access.

Binding leads to a significant increase in performance in the case of a larger index, because there is no need to frequently update the cache.

+1
source

More articles:


All Articles