CST363 Module 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 is meant by a slow index? 

This page seems to define a 'slow index' as one that returns a large amount of data from an inquiry such as when a single index can simply relate to lots of data in a table, or such as when a single index has a few matches and so the system chooses to follow their table relationships down a large rabbit hole. This page used the Oracle system functions as an example. The first situation is from their TABLE ACCESS BY INDEX ROWID and the second situation is from their INDEX RANGE SCAN.

Comments

Post a Comment

Popular posts from this blog

CST489 / 499 Week 16

  For this week, please spend time browsing through your two years of journals and reflect on your overall experience and growth in the program. Some thoughts on future plans would be great, also.   This program has been an interesting two years, we've gone over so much material and yet I know I have so much more to learn just due to the nature of this field. I hope to continue to grow as I have these past 2 years and into a position where I can leverage my new skills.
Read more

CST462S Module 8

What went well? What would you improve? What was the most impactful part? What challenges did you face? Overall I was able to complete my service hours but with some difficulty in making sure I made my weekly goal, ideally I could have started earlier to allow my site more time to assign me tasks. Our class essay went pretty smoothly throughout the course even though my group and I were dreading completing the assigned section of our essay every week. In terms of challenges for this course it was mainly just scheduling, having 2 classes at the same time with what felt like a standard workload we’ve come to expect from each with our service learning on top. If instead 462S was on it own and our graphics design course was paired up with a different course such as the web design one, then it would have been a much more manageable courseload.  What advice do you have for future SL students? My primary advice for this is to start as early as possible. Having 2 classes worth of work plus...
Read more

CST489 / 499 Week 15

  5pt: What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall. This week I was tasked with primarily working on the documentation we need for the final festival submission and the Status Update. 5pt: What is your plan for next week? Next week we plan to finish up the festival video. 5pt: What challenges, if any, are you currently facing in project development? Do you need instructor assistance? N/A
Read more