It’s hard to understand what indexes are on SQL Databases. Find out how to visualise what’s happening so you can easily follow what your database queries are doing.
The reason that indexes are called indexes is because they are very similar to how indexes in books work. As such, a good way to understand what indexes might work well is to think of the rows of data in your table as the pages in a book. Then based on the information think about what would be the best index you might find at the end of the book to allow you to quickly answer the query.
Links:
Watch the full User Group: • How to Plan for Database Performance …
Rule: https://www.ssw.com.au/rules/sql-real…
Need help? https://www.ssw.com.au/consulting
Follow us:
https://linkedin.com/company/ssw/
Twitter: https://twitter.com/ssw_tv
Facebook:https://facebook.com/SSW.page
https://instagram.com/ssw_tv
https://www.tiktok.com/@ssw_tv
Get in touch:
Bryden Oliver – Solution Architect
About: https://www.ssw.com.au/people/bryden-…
https://github.com/brydeno
For more information about SSW’s consulting services, please visit https://ssw.com.au
#database #sql #databaseperformance #data #tech #usergroup #indexes
V1- Bahjat
About the speakers
Bryden Oliver
Bryden is a Solution Architect with over 30 years of professional experience, working with customers from small businesses to the world's largest companies. He has a wealth of knowledge from a diverse range of areas, particularly focused on databases, web services, Microsoft Azure, and SaaS solutions.
Bryden has a strong understanding of how software will deliver business value. He has a laser focus on maximising value for his clients. He has become a critical part of the success of one of his large government clients, providing expertise, experience and mentoring across their organisation.
Related videos
