Week 5 learning journal CST 363

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? 

Even though the database is using an index, the query can still take a long time to run, making it a "slow index". If the database has to look through a lot of matching entries in the index then get each row from the table it can take extra time because slows down the performance. The process of following all the matches and getting the data can make it slower than expected. 

Comments

Post a Comment

Popular posts from this blog

Week 4 Learning Journal

Part 1: My goal is to graduate from the CS program with a strong foundation in software development, cybersecurity, and data systems so I can confidently land a full-time job as a cybersecurity engineer for the Department of Defense or a private defense contractor. I want to be skilled enough to pass security clearances, earn industry certifications like CompTIA Security+ and CISSP, and contribute to building secure, innovative technology that protects people and critical infrastructure. I see myself walking across the stage at graduation, proud of the hard work I've put in, and excited to step into a role where I can grow, learn, and make a real impact. Part 2: My goal is to become a cybersecurity engineer working with the Department of Defense or a top defense contractor like Lockheed Martin, where I can help design and protect mission-critical systems. I want to be part of projects that make a real difference in national security, using my skills to prevent cyber threats and bui...
Read more

Week 2 Learning Journal

Image
 Part 1: After reading the Effective Study Skills paper, I think the top 3 skills I am good at are developing a weekly schedule, making sure to read instructions to properly complete assignments, and ensuring I always have a quiet study space with no distractions. Some of these skills come with trial and error but they have proven to be most beneficial in studying successfully. I think 3 skills I need to work on are organizing my notes when researching, the SQ3R method, and making every hour count. These study skills and methods are important to practice because they will be a big step up in being efficient with studying.  Part 2: Activity log Part 3: Watching the three video presentations provided offered a lot of helpful tools that will boost my knowledge on project management. The first explained the five main phases of project management and the role of a project manager. The second showed how a Work Breakdown Structure (WBS) helps organize tasks into smaller parts for bet...
Read more

Week 7 Learning Journal

Part 1: For our team’s final research video project, we’ve been using Discord to communicate, and it’s worked really well. We chat frequently, ask each other questions, and keep everyone updated on progress. It’s been a smooth way to stay connected and make sure no one feels out of the loop. We’re using Google Slides to build our presentation and OBS Studio to record and edit the final video. So far, the process has been going pretty smoothly, but if I had to improve anything for next time, I’d suggest setting deadlines a little earlier to give ourselves more buffer room. Overall, the collaboration has been solid and productive. Part 2: This week’s materials made me think about how little things can have huge effects. I chose a TED talk on cybersecurity, I realized how something as simple as clicking a link can lead to serious consequences. It was a good reminder to stay alert online. A TED talk I was interested in was by Amy Cuddy. It was on body language and it was really interesting...
Read more