Week 21

-

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

What the author, Markus Winand, means by a slow index is that indexes are designed to speed up queries by organizing data in a search-optimized structure. However, they don't always guarantee a fast performance. This can be due to scanning leaf node chains to find all matches and fetching table data for each marked row, often involving slow random I/O. Indexes don't always guarantee fast approaches, due to the cost of large/scattered data.


As for myself, I've been trying to read every day after work. Some of the readings were a little harder to retain than others, but I've been trying to remain diligent. I've gotten a better grasp on databases and stuff like deadlocks. Just gotta keep at it.

Links to an external site.

Comments

Post a Comment

Popular posts from this blog

Week 1

-
 I'm excited to begin my first official week at CSUMB CS online! I started off the first week by going over the lecture. I learned about how we will be utilizing APA format, different sources and what is expected of us, paraphrasing, and plagiarism. I will do my best throughout the year and I believe I'm off to a great start. This Thursday I will thoroughly review the writing lab and begin. Let's have a great first week.
Read more

Week 4

-
Set Your Educational Goals      I have several educational goals. The first one is a strong understanding of core computer science concepts such as data structures and algorithms, operating systems, databases, and computer networks. A deep understanding of advanced math such as calculus, discrete math, and linear algebra will also help. With a clear emphasis on getting better at programming, that will be beneficial. I also want to have an internship and more personal projects. I then want to specialize in an area of computer science, maybe artificial intelligence as that's what I wrote for my paper but it's still up in the air. I want to be good at communicating, teamwork, and problem-solving. Set Your Career Goals      Short term wise I want to land a role in my specific interest. Whether it be software development, data science/AI, cybersecurity, or other fields. Then build technical depth and gain industry experience. I can then network with others to fu...
Read more

Week 2

-
Image
Part 1:      The first thing I'm good at is schedules, I agree there is a ton of value to schedules and they save an immense amount of time. Figuring out what days and hours I have available to do what work also relieves stress on my mind because I know I will figure out those problems when my availability is open to do so. One thing I'm not good at is not storing my notes in a good place. I'm scatterbrained in that sense so according to this effective study skills document I should try and consolidate my notes for better retention of information. The second thing I'm good at is answering easy questions first, as soon as I'm stumped I skip past it to let my subconscious handle it and get on an easier problem. Another thing I'm bad at is reading multiple-choice questions, I have a bad habit of rushing so I need to take some time to read the questions multiple times to make sure I understand what is being asked. I do have a good study space, that is quiet and comf...
Read more