CST 363 Wk5: Slow Indexes

 Well hello! it's been awhile hasn't it?


Even though indexes are generally fast and enhance query performance, but if the database is poorly designed and/or maintained then the index would have a negative effect on performance. For example table data can be unsorted and the index scan has to search all matching indexes instead of just finding a single matching value. .

Comments

Post a Comment

Popular posts from this blog

CST 363 Wk7:

 I 100% prefer MongoDB, it's very intuitive compared to SQL statements, since it's more modern.   Some similarities are the CRUD operations, which makes going from SQL to MongoDB easy to handle. I do like how flexible the data is stored in MongoDB rather than SQL.
Read more

Week 4 Learning Journal

 Part One: Set Your Educational Goals I'd like to focus on developing an excellent portfolio of projects to show case my programming and creative problem solving skills.  How that goal is judged will depend if I can change my career from mechanical engineering to programming! Part Two: Set Your Career Goals I'd like to have a software oriented role, which can be in a variety of fields, but my main goals would be in flight/physics simulation modeling and/or thermal simulation modeling.  Either developing the models themselves or the software that engineers use to solve these types of issues. Part Three: In 18 months, I think I'd do really well, maybe in 70-80% percentile.  I'm genuinely interested in learning computer science topics so it will be a fun journey forward.  Part Four:  I finally caught up on all my coursework after falling behind in the first couple weeks, so I'm glad to have learned more content this week.  This week after working on my ou...
Read more

wk2: Trust the Process

 In the year 2012, Kobe Bryant was having a season filled with injuries and ups and downs, but confidently he said to "Trust the process" in order to achieve his goal of another NBA championship.  While he wasn't able to get this sixth championship, his saying still lives on.  Though I'm sure Kobe wasn't aware that trusting the process lies within our computers that allows them to perform whatever we tell them.   I've learned the interesting bits about how the OS manages processes through the fork() and exec() commands, which appear simple but allow the OS to perform multiple processes.  I later learned about how the OS manages permissions between the user and kernel, so the user can temporarily access higher permissions through the use of traps. Also fun to think about the potential of traps if one were to gain access, they can run malicious code.
Read more