Week 21 (5/28/2025 - 6/3/2025)

   (Click on READ MORE for better formatting)

    Hi everyone, welcome to my 21st blog! This is the Week 5 post for CST 363 Introduction to Database Systems.
  • The website "Use the Index Luke" has a page on "slow indexes". https://use-the-index-luke.com/sql/anatomy/slow-indexes. If indexes are supposed to speed up performance of query, what does the author mean by a slow index?
    • The author, Markus Winand, states that there are three steps to an index lookup. They are:
      • The tree traversal
      • Following the leaf node chain
      • Fetching the table data
    • According to Mr. Winand, the only step with an upper bound for the number of accessed blocks is the index depth (tree traversal step). This means the two steps that follow have the potential to cause a slow index lookup. The author also mentions how Oracle database has three distinct operations to describe a basic index lookup:
      • index unique scan
      • index range scan
      • table access by index rowid
    • The author concludes that the index range scan can still be a slow query despite the utilization of indexes if there is an additional table access for each row.

    That is all for this week, see you in my Week 21 post!

Comments

Post a Comment

Popular posts from this blog

Weeks 65 - 72 (4/27/2026 - 6/21/2026)

          (Click on READ MORE for better formatting)      Hi everyone, welcome to my 65th-72nd  blog!  This is the Week 1-8 post for a bit of an awkward time in my CSUMB CS Online journey, and one that quite frankly happened by chance. It was discovered that I was not required to take CST383 Introduction to Data Science in order to graduate from the program. As a result, I decided to drop the course and instead take the Summer 2026 A term to recharge after a little over a year of near-nonstop grinding in this program.     That being said, the idea of considering an online program for a M.S. in Computer Science has been in the back of my head basically since the beginning of my B.S. in Computer Science here at CSUMB. Since I now have this newfound eight weeks of free time, I believe now is the perfect opportunity to begin preparing my graduate school applications. To be completely honest, there is really only one school I a...
Read more

Week 73 (6/22/2026 - 6/30/2026)

       Hi everyone, welcome to my 73rd  blog!  This is the Week 1 post for CST 438 Software Engineering. What did you expect a course in Software Engineering would cover? After completing week 1, how has your opinion changed? This question actually brings up an interesting nuance. If you had asked me this prior to entering the industry as a software engineer (December 2025), my answer to this question could have been completely different. Since I have already entered the industry, I was genuinely impressed how much the orientation of this class sounded like a pretty accurate rendition of the current status quo in the industry. For example, I appreciated that Prof. Wisneski understands the relevancy of agentic development via tools such as Claude Code, which is something I use at work every single day. To be more specific, I run most of my prompts on Claude Opus 4.8 1M context. Thankfully, my work has me on a Premium seat of Anthropic's Team plan. This is so...
Read more

Weeks 41 - 48 (10/26/2025 - 12/19/2025)

     (Click on READ MORE for better formatting)      Hi everyone, welcome to my 41st-48th  blogs!  This is the Week 1-8 post for CST 336 Internet Programming. Similarly to CST 311 Introduction to Computer Networks, while journal entries were not required  for this particular course, I wanted to document the concepts and assignments from each week of class. If you would like to see some of these projects for yourself, this link acts as a homepage to visiting all of the projects described below! https://bevans34.github.io Week 1: HTML and CSS This week's primary focus was on learning/practicing creating a website using H yper T ext M arkup L anguage (HTML) and C ascading S tyle S heets (CSS). Highlights from this week included centering a <div>, which is probably one of the biggest memes to ever come out of web development. Labs: 1 - ePortfolio Site In this lab, I created a site hosted on GitHub Pages that features a homepage, about page,...
Read more