Databases System: Week 5

-

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

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


    Indexes are known for speeding up the performance of a query but it is not the case for certain situations. The author means that the slow index is being caused by a specific reason. One reason is following the leaf node chain makes an index slow because of multiple leaf nodes that are potential matches for the query. Another reason is accessing the table by index ROWID which can cause indexes to be slow due to the amount of data being read which can be large. Indexes can help the performance of a database but in some cases, they can't due to a badly constructed query.

Comments

Post a Comment

Popular posts from this blog

My first week

-
I am excited and eager to have started this journey with an amazing cohort and faculty!  The material I reviewed included tips to help me be successful in our online program and the syllabus. D uring module 0, I made a weekly study schedule, and it was my first time making one. It was very interesting and helpful to use. I enjoyed interacting with my cohort and getting familiar with everyone during our discussion. Besides that, my wonderful teammates and I started working on our assignment early which included having a team name and making a collective resume as if we had a business. I suggested a few team names and my teammates agreed on Code Busters. We managed to work together to make our resume and the only thing we could have left out was AI. Our business consists of helping our customers debug their systems. (Our collective resume is included below.) Now continuing to Module 1 my team and I started off the week right by finishing our assignment the day we received it. We rev...
Read more

Second Week

-
Here are the following parts of this week's learning journal assignment. Part 1:  The three things I am good at are asking questions, taking notes, and gathering my materials. When looking over material or doing assignments, I always have questions, and I try to figure them out to understand what I am doing. In the SQ3R method, questions are great for learning because it covers the why, what, how, who, where, and when. I also enjoy implementing note taking. I have a notebook for my CST 300 class, and I also use my notes on my computer to make sure I get everything done. Taking notes helps memorize what you are writing. I am also good at having my materials on my desk where I study. I keep everything together so it’s easily accessible. The three things that I need to work on more are time management, where I study, and having a correct schedule that works for me. I always struggled with time management, and I felt it this week because I did several assignments on the day it was due....
Read more

Fourth Week

-
 Part 1: One educational goal of mine is to receive As and Bs throughout my journey in this program. This aligns with my second educational goal, getting a 180 out of 200 on my Ethics Argument Essay in my CST 300 class. I want to accomplish this goal by getting help from others. During this class, I received an 84 out of 100 on my Industry Analysis essay. I wasn’t too far out but the Ethics argument essay will be difficult. My last educational goal is to get ahead of my assignments by managing my time. I am always busy studying, working, being with my family, and trying to leave time for myself. I spend over twenty hours trying to figure out or perfect assignments and reviewing them in the Modules. Part 2: My career goal that I can work on is making projects to start my portfolio. Starting this can help recruiters and myself to acknowledge the progress I will be making. Considering I will have more knowledge by the end of this program. I also want to learn new program languages and...
Read more