Wednesday, October 2, 2024

CST363 - Week 5

Include in your journal entry for this week the following

The web site "Use the Index Luke" has a page on "slow indexes". https://use-the-index-luke.com/sql/anatomy/slow-indexesLinks to an external site.

If indexes are supposed to speed up performance of query, what does the author mean by a slow index?


While indexes are generally used to speed up the performance of database queries, there are cases where they don't work as efficiently as expected. Markus Winand explains that a "slow index" occurs when the database has to follow a chain of leaf nodes continuously checking for matching entries, and also access the table. These steps may involve accessing many blocks, which can slow down the query rather than improve its performance.
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

CST462S - Service Learning Experience

With the first half of my Summer semester now coming to a close, I am submitting my final assignments and preparing for the upcoming class i...

  • CST334 - Week 6
    Write what you learned this sixth week in CST 334 Topic: Semaphores This week, we continued learning and explored the topic of semaphores an...
  • CST334 - Week 3
    Write what you learned this third week in CST 334  Topic: Introduction to Memory Virtualization This week, we read about how computer memory...
  • CST334 - Week 7
    Write what you learned this seventh week in CST 334 Topic: Persistence This week, we covered a critical area of operating systems—persisten...