SQL Indexing and SQL Performance Part 2: Clustered and Non-Clustered

2015-06-09T11:34:07+02:00Tuesday, 30 November, 2010|Categories: Technical|Tags: , , , , , , , , , |

So, why do you need to index your tables? Because without an index the SQL server has to scan the entire table to return the requested data. It is like the index page in a book. You check within the index for the keyword you want to learn about. From that point forward, you jump directly to [...]