Heres how to get started with indexing. This covers the basics to help a developer get started creating indexes on SQL databases.
Want to develop your SQL Server Database with SSW? Check SSW's Databases Consulting page.
It's hard to understand what indexes are on SQL Databases. Find out how to visualize what's happening so you can easily follow what your database queries are doing.
Database indexes get their name from book indexes because they work similarly. To grasp how they function, imagine the rows in your table as pages in a book. Then, consider what kind of index in the book would help you quickly find the information you need.
So you've identified that you need to improve the performance of a SQL ORDER BY clause. How can you create an index to improve the performance?
So you've identified that a WHERE clause is causing query performance issues. How can you create an index to alleviate the problem?
So you've created some indexes. How can you go about verifying that the indexes have actually improved the performance of your queries?
So you've identified that you need to improve the performance of a SQL JOIN. How can you create an index to improve the performance?
Feel like you don't know enough to manage the indexes on your SQL databases? SQL Server and Azure SQL databases have that covered for you.