Answers.Body: <p>The text book I use for teaching database indexing is "Database Systems Concepts" by Silberschatz, Korth and Sudarshan. The book is regularly updated to keep pace with the multiple advances happening in the data management domain. </p>
  
  <p>The chapter on indexing in the book is good and has a few examples. You can get a feel for the examples from the slides made available by the authors at <a href="https://www.db-book.com/db7/slides-dir/index.html" rel="nofollow noreferrer">https://www.db-book.com/db7/slides-dir/index.html</a></p>
  
  <p>For B+tree indexing, you can find many visualisation tools online. I have used the below one on many occasions:
  <a href="https://www.cs.usfca.edu/~galles/visualization/BPlusTree.html" rel="nofollow noreferrer">https://www.cs.usfca.edu/~galles/visualization/BPlusTree.html</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-28T08:46:36.353Z
Answers.LastActivityDate: 2019-11-28T08:46:36.353Z
Answers.UserDisplayName: bkm
Answers.Body: <p>The <a href="https://en.wikipedia.org/wiki/Database_index" rel="nofollow noreferrer">wikipedia</a> entry is informative. </p>
  
  <p><a href="https://rads.stackoverflow.com/amzn/click/com/0131873253" rel="nofollow noreferrer" rel="nofollow noreferrer">Database Systems: The Complete Book</a> by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom  is probably good. Older versions of database books by Ullman have been accurate and reliable. I haven't seen the latest version, though. </p>
  
  <hr>
  
  <p>Actually, most of my experience with Ullman has been his compiler books, not database. Still, though, a reliable person. More than just a random author. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-12T20:19:58.387Z
Answers.LastActivityDate: 2019-11-12T20:57:43.170Z
Answers.LastEditDate: 2019-11-12T20:57:43.170Z
Answers.UserDisplayName: Buffy
Body: <p>Is there any good source/textbook with notes about db indexing with examples?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-13T14:02:24.307Z
Comments.Text: Is this a [tag:self-learning] question?
Comments.UserDisplayName: Ben I.
Tags: <resource-request><databases>
Title: Materials on database indexing with examples
ThreadText: # Materials on database indexing with examples
  
  (Asked by: username_0 on 2019-11-12)
  
  Is there any good source/textbook with notes about db indexing with examples?
  
  **Tags:** resource-request, databases
  
  > **Comments:**
  > **username_1**: Is this a [tag:self-learning] question?  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2019-11-28. Score: 1
  
  The text book I use for teaching database indexing is "Database Systems Concepts" by Silberschatz, Korth and Sudarshan. The book is regularly updated to keep pace with the multiple advances happening in the data management domain.
  
  The chapter on indexing in the book is good and has a few examples. You can get a feel for the examples from the slides made available by the authors at <https://www.db-book.com/db7/slides-dir/index.html>
  
  For B+tree indexing, you can find many visualisation tools online. I have used the below one on many occasions:
  <https://www.cs.usfca.edu/~galles/visualization/BPlusTree.html>
  
  
  ---
  
  ### Answer by username_3 on 2019-11-12. Score: 1
  
  The [wikipedia](https://en.wikipedia.org/wiki/Database_index) entry is informative.
  
  [Database Systems: The Complete Book](https://rads.stackoverflow.com/amzn/click/com/0131873253) by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom is probably good. Older versions of database books by Ullman have been accurate and reliable. I haven't seen the latest version, though.
  
  ---
  
  Actually, most of my experience with Ullman has been his compiler books, not database. Still, though, a reliable person. More than just a random author.
  
  
  ---
  
  