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-indexesLinks to an external site.

  • If indexes are to speed up performance of query, what does the author mean by a slow index?
Sometimes indexes can be used in inefficient ways leading to slow queries despite the use of an index. This can happen in different ways but the main two come from either an index not properly filtering out rows or a query can be written in an inefficient way. When an index is designed in a way that many rows with duplicate values are returned it could be the result of an indexed column designed with low selectivity. In the instance of queries written in inefficient ways it could be due to misusing the indexes design resulting in many rows being returned.

Comments

Post a Comment

Popular posts from this blog

CST300 Week 2: Drafts and Peer Reviews

Image
Part 1. Review and Reflect Learning Strategy      The top 3 effective study skills that I am strong in are Surveying, Making and revising a schedule, and Recite. Anytime I am presented with a new set of coursework I carefully overview the material and create a study plan allocating the time that will be required to cover and review it.      The 3 I am weakest in are Outlining textbooks, Where to study, and reciting. For one, I don't typically mark on textbooks, I also typically study at my computer which can often lead to distraction if I'm not careful, and lastly I can sometimes find myself reading through a section without fully grasping what I just covered.   Part 2: Preview Time Management Skills Part 3: Project Management Basics     The three video presentations, Introduction to Project Management, A WNS Masterclass, and Project Management in Under 5, were all incredible resources in learns key aspects about project management. The ...
Read more

Week 4

  Part One: Set Your Educational Goals     I have always told myself that I want to continuously develop my skills as a developer. There is always more to learn and new avenues to explore. As far as a set in stone goal to achieve, completing my Bachelor's is first and foremost. Once I achieve that I can start focusing on other certifications that may be beneficial to my career. Part Two: Set Your Career Goals      For my career goal, I hope to one day be in the position to design software systems. I enjoy writing code, but its always been building more than just producing that has fascinated me the most. My ideal role would be as a Software Architect. As an architect more of my responsibilities would revolve around developing the overall structure and project design rather than just working on coding tasks.     Even beyond that, it is a dream of mine to open a game development studio. Much of my spare time is spent working on small personal p...
Read more

Interview With an Industry Expert

Introduction      Today I interviewed Hirokazu Tei, a friend of mine who currently works as a Senior Software Engineer at Snowflake, an AI cloud platform in Seattle. I selected Kaz because he is a very bright, successful software engineer who I have known for many years. With an impressive track record, having worked at companies like Nextdoor and Twitter, I knew he would be a great source of knowledge and could provide me with tips for a successful career in the tech world. Summary      Kaz told me that to guarantee a job as soon as possible I should search for internship opportunities. He explained that working within a company will teach me things that can't be learned in an academic setting. He mentioned that in recent months recruiters have been reaching out over Linkedin meaning that many see the end of the hiring freezes that companies have been experiencing. Additionally, if I am struggling to find an internship I should use my available time to wor...
Read more