Learning Journal Week 05 - CST363-30_2253

 Flavio Cervantes

06/03/2025

 

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

   The author means by a slow index is when the incorrectly configured  indexes are used for a certain database, hence it causes inefficiency within the lookup. He informs us slow indexes are mistakenly diagnosed and administrators perform indexes rebuild as the "fix all" solution, but this is the incorrect method of fixing slow indexes.  According to Markus Winand, he explains that an index lookup requires a. tree traversal b. following the leaf node chain c. fetch table data - if any of these are configured poorly, then that will be a culprit for performance degradation. (eg: an inefficiently written "where" clause can cause a slow query) 

 

 

 Reference: https://use-the-index-luke.com/sql/anatomy/slow-indexes


Comments

Post a Comment

Popular posts from this blog

Learning Journal - CSUMB - January 6, 2025

 Greetings,     This week I learned about the campus of CSUMB, and how it was a military base before officially becoming a CSU in the mid 90's. The vision of our school is based on collaboration, teaching us skills that are essential for the modern workforce, and to provide the best possible curriculum with relevant technologies that will help us excel in our future, if we do our part and endeavor the challenges that Computer Science conveys. I also learned about the different ways to format APA style, depending if it is a website, book, or personal interview. At my previous schools, we would utilize MLA, so this is a great learning experience.  I also refreshed on the importance of plagiarism, and why it is extremely important to do on our work, even with all the tools we have such as AI, 3rd party websites, etc. The challenge I overcame this week was to have a deeper understanding of how Dynatrace operates, and all the different components that shape a successf...
Read more

Learning Journal - Week IV

     Educational Goals My education goals in the CS program are to strengthen my engineering foundational skills. I also want to strengthen my programming skills by expanding my knowledge in python and Unix. I am working on obtaining a stronger understanding in machine learning, artificial intelligence and software engineering. This will be accomplished by working on small scale assignments or projects that introduce me into these respective technologies.  Career Goals My career goal is to continue to promote within the company I am currently working at or to move to another company and take on a more challenging engineer related role such as an Architect III or  Software Engineer. Wild guess of your percentile of the ETS Computer Science test After viewing the ETS page, test description and sample test I feel that this test will challenge me greatly but is a great standard as a computer science major. The percentile that I feel I will obtain is arou...
Read more

Learning Journal - CSUMB - January 15, 2025

Image
      Lecture: Week 2 Learning Journal Post      Part 1: Review and Reflect Learning Strategy       The tops three areas that I am good at is to stick to my schedule, unless an emergency comes up, I like to stick to my schedule from the beginning of the day, until the end of the day. I am also good at studying when I have "planned" for it, I usually plan my studies in the evening and over my online educational journey, I have been disciplined enough to stay on track. Lastly, I am good at thinking skills, I can think critically, and come up with ideas or a desire to research something and learn about it. This ability is used in our everyday life’s, at home, while studying, and at work.  The top three areas that I feel I am weak in is where to study, sometimes it is easier to study at home but that is where I can easily get distracted at. I also feel that I am weak in is reading, sometimes when I am tired, it is hard to read all the m...
Read more