CST363 Week 5

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

Links to an external site. 

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


In the article "Slow Indexes" from Use the Index, Luke!, the author explains that not every index lookup is automatically fast. A "slow index" happens when the database still has to do extra work after finding the right index entries. An example of this would be if there were multiple matching rows, the system has to follow the leaf node chain, and then access the table data for each match. These table blocks might be scattered, which increases input and output operations with the storage system and slow things down. In other words, the index itself is not corrupt, it just contains such a huge amount of data that it makes the query run slower than would have been expected, still accessing the index.

Comments

Post a Comment

Popular posts from this blog

Week 4 - Goals!

 Part 1: Set your Educational Goals My educational goal in the CS program is to graduate with a bachelor’s degree in computer science with a strong understanding of software development, systems architecture, and AI systems. I hope to continue to maintain a GPA of at least 3.5 or above, complete internships, and build a portfolio of coding projects. I will work to improve my problem solving skills and work well with my team members on projects. This goal motivates me to keep pushing because it goes further than graduating, it is the start of my life, my career. I will track my progress through grades, internships, and my ability to apply what I have learned to the real world. Part Two: Set your Career Goals My career goal is to become a systems architect at the well-known company, NVIDIA. Working on the design and optimization of hardware or software integration for AI and GPU based systems is a dream. I can see myself contributing to the next generation of computing solutions, whe...
Read more

Week 2 - Second week of class!

Image
Part 1: Review and Reflect Learning Strategy The top three items that I am good at is making a schedule, picking good study habits, and taking good notes. The top three items that I feel I am weak in is test taking, essay examinations, and not reading aloud to myself. I always try to follow the same schedule each week because I am a habitual person. I find repetition and using flash cards to help me study. I love taking notes, it helps me retain more information. I struggle in a testing environment because I get in my head, which is the same struggle when it comes to essay examinations. I enjoy reading my work or assignments out to myself because I feel like I do retain more, but I will try reading in my head to see if I benefit from this! Part 2: Preview Time Management Skills Part 3: Project Management Basics A project is a task that ends with accomplishing a goal or creating something. There are three things that describe a project as a whole, the time it will take to complete this ...
Read more

Week 4 - Interview with Industry Expert

Interview with Josh Hobson:      For this assignment I chose to interview my uncle, Josh Hobson, the current Direct of Technology at Santa Monica Studios, a well-known video game development company. He has a Bachelor’s degree in Computer Science from California State University, Bakersfield, and a Master’s in Engineering from Arizona State University. I chose to interview him not only because of his many accomplishments, but because I have always admired his passion for technology and his creative mind. His experiences, from graphics programming to technical leadership, offered a unique and personal perspective on what success looks like in the gaming and technology industry.     Josh shared that his career passion began when he was young. His love for working on computers sparked an early interest in the field. He explained that his fascination with computer graphics ultimately led him to specialize in rendering systems, where he focused on per...
Read more