CST363: Learning Journal Week 5



Just stopping by for my weekly journal for CST363. I don’t have anything to say except that I’m glad there were no Java based assignments this week. I just hate Java. On to the question of the week!


The web site "Use the Index Luke" has a page on "slow indexes". https://use-the-index-luke.com/sql/anatomy/slow-indexesLinks to an external site.

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

What Markus Winand is trying to convey on that page is that slow indexes are situations when an index can be slower than a normal query. He explains how indexing works then says that slow indexes are a myth stemming from the misunderstanding that slow indexes can be caused by improper tree structure. Apparently most databases can tell you how they use an index and using that insight can help developers optimize how they index their databases.

Comments

Post a Comment

Popular posts from this blog

CST438: Journal Entry Week 1

Q. What did you expect a course in Software Engineering would cover? A. I believed we'd be building desktop applications with graphical user interfaces. Q. After completing week 1, how has your opinion changed? A. It turns out we're working on web services instead. I think that my personal preference toward desktop apps over web-based ones, especially regarding sensitive information and potential security concerns, is why I had the wrong initial impression.
Read more

CST370: Journal Entry Week 3

Week 3 is ending already! We learned about brute-force string matching as well as depth and breadth-first search algorithms. I was already familiar with the divide and conquer algorithm design, but it was still good to read more about it. The homework this week was torture. The first program about Depth-First Search took me forever to do and I found the instructions to be confusing. The hint really saved me on that one. The second program was easier in the way that we just needed to use brute force over more complicated algorithms. Anyways that’s all for now. The midterm is coming up soon and I hope I’m prepared for it.
Read more

CST311: Journal Entry Week 7

We covered chapter 6 of the textbook which was about link layers, but that was overshadowed by the much bigger thing this week, the final exam. One difference I noticed between the midterm and the final was that the midterm had much more overlap with the pre-midterm questions than the final had with the pre-final. That didn’t turn out to be much of an issue since I still scored pretty well in the end. This class is basically over now. I’m not bothering with any more extra credit work since it won’t make a meaningful difference to my grade since I already have an A. There’s just the programming assignment 4, and chapter 8.9 quiz, and the week 8 journal, which I probably won’t have much to say in since I’ll have to turn that in within 4 days from the date this one is published. That’s all for now.
Read more