What exactly happens during Index Block splits?
584429Nov 5 2009 — edited Nov 5 2009Hi,
I'm trying to understand the internal workings of regular B* tree indexes and a couple of questions have been bothering me. So far I can't get clear understandings of the followings:
1. Will an Index block split necessarily result in a new branch/root node?
2. At what time (if ever) will the blocks in the root node be split?
3. Are locks held on the whole index while block splits are performed
4. How will the split occur, supposing more than two sessions are inserting into the index and the block splits have to occur in different blocks, different branch nodes? Will there be separate locks?
5. Which view can I query to see waits related to index block-splits?
I appreciate any answers or reference to good materials on this.
dula