CST-363 Week 5

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

Links to an external site. 

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

There may be additional costs that need to be made depending on the query. The author states that leaf node chains and table access may slow down lookups. If there are multiple matching entries in a lead node, the database will have to continue to reading data in the next leaf node. If there are multiple rows in a table that is pointed to from an index, each one would need to be read, decreasing performance.

Comments

Post a Comment

Popular posts from this blog

Week 5

 Part 1 Support Teammates' goals. Teammate comment (Ysabelle):  CST300 Week 4 Second comment (Faith):  Week 4 Learning Journal Part 2 Possible Capstone. I am mainly interested in mobile development, so I think some possible capstones I could work on could have the goal of making user's life more convenient.  An application for businesses to create a virtual loyalty card which allows them to send a text message of a user's QR, so they can scan their card and "punch" it. An application for users to track their workouts. They will be able to create custom workouts and track sets, rest time, reps, weights, etc.  A third idea could be working on an existing application that allows open contributions from students. Part 3 Learning Journal AI In Writing Using AI to complement your writing can benefit you by improving your reading efficiency and content creation. Instructive prompting: Used to guide your AI to a specific task. Output must be inspected to ensure it is re...
Read more

Week 4

Part 1 Educational Goals. My main educational goal is to achieve my bachelor's degree in computer science in 2 years. Another educational goal of mine is to do well in my upper division classes so I can be prepared for a career in software development. I would also like to strengthen my collaboration skills through the use of group projects.  Part 2 Career Goals. One of my main career goals is to become a professional software developer after graduation. I hope to leverage my current internship as an Android developer to find a new internship next summer, so I can explore different fields in software development. Part 3 Guess ETS percentile. If I had to guess, I think I would be in the 70th percentile. I feel pretty comfortable with programming, but I think I would struggle more with the theory-based questions and would have to review my notes from discrete/data structures beforehand.  Part 4 Learning Journal.  Writing material:  For my Ethics essay, I will need to c...
Read more

Week 2

Image
Part 1. The top 3 items I am good at is taking notes, reviewing easy questions on exams first, and setting a schedule. I think one area I could improve on is asking the right questions. Part 2. Log        Part 3 Project Management basics.      Companies have experts that focus on project management. A board of directors will decide on a project to be completed while a project manager essentially acts as CEO over that project. The work breakdown structure is a fundamental tool of project management. It is common to break down projects into its own products/deliverables. To create a work breakdown structure, you create a hierarchical decomposition of all the deliverables. Level 0 is the project. Level 1 is the Keyline (organizing principles). Level 2 is the Major Deliverable. Level 3 is sub-deliverables (helps meet end deliverables). Level 4 and further decompose sub-deliverables. Finally, get feedback before presenting final work breakdown structure. Ea...
Read more