CST363 - Week 5

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

The author suggests that slow indexes can be caused by the leaf node chain, which may lead to performance issues depending on the number of entries. Additionally, an index range scan can contribute to this slowness when it involves traversing the leaf node chain.

Comments

Post a Comment

Popular posts from this blog

Module 2:

Image
       After reading about effective study skills, I’ve noticed that while I have some experience, I haven’t mastered skills like taking notes, outlining textbooks, and organizing my notes for revision. My weaker areas are managing my time, revising my schedule, and making every hour count.      One management skill I need to improve is prioritization. I tend to leave important tasks until the last moment, and I should learn to avoid this. Additionally, I need to work on overcoming procrastination.      I understand the importance of effective project management for achieving success, and I’ve found that some strategies are very helpful. For example, the Gantt Chart is something I’ve heard of before, but I only learned about it in detail recently. Starting with a Work Breakdown Structure and creating a chart are useful strategies to complete tasks within the required timeframe.      My top three picks from the previous cap...
Read more

Module 4:

 My educational goal in Computer Science is to develop my front-end skills, as I feel I lack knowledge in design and color palettes. I also want to learn more about operating systems, but I’m still unsure about what the course covers. The books I’ve seen mainly focus on learning Linux commands and programming in C. I don’t have a specific career goal in Computer Science besides wanting a job where I can work from home. I’m not ready to leave the valley where I live, but I’m considering it since I’m pretty sure there’s no job market for CS here. I’ll be ready to take the test in 18 months, and I’d like to achieve an 80% score. This week was focused more on reflecting about my career, AI, and team collaboration. It was interesting to think about these topics.
Read more

Module 5 - 338

I worked with Rene, Krithika and Joseph on this assignment. For this assignment , I decided to start well in advance of the due date . I began by reading the prompt before starting the work . When writing the code , I started with the smallest function , as well as the first one required to make the others work . Finally , the last method I implemented was addFromFile . This strategy gave me plenty of time to check for errors . The strategy my classmates used was for all of us to read the prompt before starting. Joseph decided to follow the methods in order, but if a method required another to function, he adjusted the sequence. Krithika began with the easiest method first and focused on the one necessary to make other methods work. Similarly, Rene referred to past discussions to identify the easiest methods to start with. I believe my strategy worked well for this assignment because it was not too complicated. I only struggled with one method because I didn’t fully understand that par...
Read more