CST 363: Week 5

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

The author indicates that a slow index occurs when a query performs slower than expected despite using an index. To ensure a query has found all entries matching the search criteria, the database will need to read all the nodes within the final chain, which will consist of a large number of operations and slow the process. In addition to the database's need to read all the nodes within the chain, the database will also need to read data from different table blocks, which will only slow the process even more. The author specifies that though a slow index can consist of slower than normal queries, it doesn't necessarily mean the index is broken or useless. 

Comments

Post a Comment

Popular posts from this blog

Week 2 Learning Journal Post

Image
  Part 1: Learning Strategies When it comes to learning strategies, three areas I feel I am good at are creating an adequate study space, establishing study habits, and taking notes. Before I study, I make sure to clean my desk area and have drinks and snacks nearby for easy to reach replenishment. Then when I study, I make sure to add my notes in OneNote along with my assignment and quiz due dates so I can make sure to highlight and organize details based on when something will be needed for either. As for study habits, I make sure to set a timer so I don't sit down for more than 2 hours at a time so I can make sure to move around or give my brain a rest. Additionally, three areas I believe I am weakest in are writing papers, answering easy questions first, and not reading aloud. These all have a tendency to make me take longer doing assignments than I should have to. When I am writing a paper, like our industry analysis paper, I get so stuck on the words I am choosing and whether...
Read more

Week 1: Learning about CSUMB and the CS Major.

    This week, w e learned more about California State University Monterey Bay (CSUMB) and its school for computing and design (SCD). Prior to this course, I only had consideration for the computer science (CS) degree program, and it did not occur to me what else the school had to offer. It was interesting to learn about the campus' origin as an army base turned university and inspiring to hear how the university aims to mold their students into what sounds like successful and contributing individuals.      In addition to learning more about CSUMB and the SCD, we also began to work on our first essay outline and conducted a review of APA style formatting for referencing sources. I took a small number of English courses at my community college, so taking the time to review APA is essential for me to succeed in this course. For my essay, I decided to do an analysis of the cybersecurity industry, which is where I hope to work in after graduating.    ...
Read more

Week 3 Learning Journal Post

Part 1: Time Management and Study Strategy There was a short period of time when I first started college that I would go to the library to study, but that caused me social anxiety and I began focusing more on those around me than my work, so I just study at home. To improve my notetaking, I am going to try using the split page method and using colors. Additionally, I stated last week that I spent more time that I had allotted for my essay draft, so something new I plan to try is not to be a perfectionist and prioritize better.  Part 2: Learnings from This Week In addition to the other parts of this post, we gathered together with our teams to look into the various courses that are offered within the computer science (CS) curriculum and how they may serve an importance to us as CS majors. Additionally, we reviewed our Individual Learning Plans which indicate what courses we are expected to take and when we will take them. We also took some time to learn about how well we can read ot...
Read more