CST 363 Week 5

 

WELCOME TO WEEK 5

Learning Journal - Slow Indexes: 

 This week, I learned about the concept of slow Indexes. A "slow index" does not refer to a literal slow index, but rather to cases where using an index does not give the expected performance boost in query execution. This misconception comes from the misunderstanding of index functionality. An index lookup requires three steps: 

  1. The tree transversal.
  2. Following the leaf node chain.
  3. Fetching the table data.
Therefore, the idea of a slow index is caused by a broken or unbalanced tree is incorrect. Databases use various operations like IDEX UNIQUE SCAN and INDEX RANGE SCAN depending on query specifics. A slow index highlights the complexity of optimizing databases and the importance of multiple factors beyond simply having an index to enhance performance. 

Comments

Post a Comment

Popular posts from this blog

CST 300 Week 1

Image
WELCOME TO WEEK 1           Week 1 out 100 has begun! Im thrilled to share my journey while completing the CS Online program at California State University Monterey Bay. I can't wait to see what the next two years will bring.  https://www.prepbaseballreport.com/upload/school_logos/thumbs/334_thumb.png      This week I read a little bit of the history of CSUMB. It used to be an Army Base, Fort Ord, from the 50's to the 70's. Well known celebrities such as Clint Eastwood and Jimi Hendrix received training at Fort Ord.       I learned a few tips in order to succeed in online learning. The one that stood out the most was the importance of creating an organized schedule and planning study sessions. The online learning environment can make it easy for students to procrastinate. Therefore, engaging with others and logging into canvas at least three times a week should be helpful to maintain focus. Looking forward to next week!   
Read more

CST 300 Week 4

Image
  WELCOME TO WEEK 4 Educational & Career Goals This I learned that it is essential to use these 7 Career Goals in order to succeed:  Self-Assessment Networking Tracking Accomplishments Know Your Worth  Update Your Skills Negotiate Allow for Downtime https://cdn.shortpixel.ai/spai/w_1052+q_lossy+ret_img+to_webp/tipsforlawyers.com/wp-content/uploads/2021/01/Goal-setting-2048x1152.jpg      Tracking accomplishments is one goal that I want to apply to my career. It will help me in the future when I begin applying for jobs. Having everything documented will save me from trying to remember things and possibly leaving things out. This goal will also help me create my portfolio. Another career goal that I want to apply is to update my skills and begin networking. For instance, updating my skills by learning new programming languages, will be beneficial when being considered for interviews. Networking will also be beneficial, as job recruitment has changed from what it used to in the past. 
Read more

CST 300 Week 3

Image
       WELCOME TO WEEK 3 Work Styles & Conflict Styles      This week, I learned about the different work styles there are and conflict styles in action.  Each work style, whether it's about getting it right, getting it done, getting along, or getting appreciation, seeks something distinct. For instance, Get it Right wants the facts, to focus on details, and values being right. Get it Done on the other hand, focuses on deadlines and is not afraid of mistakes. They also focus on tasks being done and speeding up. Get Along is people oriented, they are aware of the needs of others, are social, direct, and want everyone satisfied. Last but not least is Get Appreciation. They tend to like to contribute, give positive feedback, and they like assertiveness.      I also learned about the different conflict styles, which are: Avoiding Forcing Accommodating Compromising Collaborating. https://www.red-thread.com/wp-content/uploads/sites/779/2016/08/Blog_Header_work-style.jpg?w=1770&h=
Read more