Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions.

It is part of a test question, where students were asked to define and describe pinning in relation to indexes.

Does anyone have an idea?

share|improve this question

closed as off topic by mgorven, RobM, rnxrx, Michael Hampton, Scott Pack Oct 2 '12 at 18:28

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

"pinning" in Oracle parlance basically means "ensure that this is always kept in memory".

It is frequently used for hot indexes that see a lot of queries against them, but might ordinarily age out of Oracle's cache (and thus have to be re-read from the disk). By pinning the index in memory the index scan will theoretically never require a disk access. If the index is large and the cache cycles frequently this could be a substantial performance improvement over frequently refreshing the cache.

share|improve this answer
Many thanks for your reply! Do you think you could link some sort of explanation as I need to read about it in detail. Or is there possibly another word for it? – Database User Jun 1 '12 at 19:04

Not the answer you're looking for? Browse other questions tagged or ask your own question.