SQL Server, benchmark's time! "Singleton_lookup Vs. Range_scan" and "Index Vs. Unique Index"
Hi Guys, I know I know! It's Friday night, are you waiting for dinner, sipping a good glass of sparkling white wine and you don't know what to do? Don't worry, I'll take care of it. Here is a post that will take you just 5 minutes! Some time ago we talk about Singleton_lookup and Range_scan . You can read here: SQL Server, Is a Seek Always Only a Seek? Singleton Lookup and Range Scan and SQL Server, Is a Seek Always Only a Seek? Singleton Lookup and Range Scan. Part 2 ...some other infos. We were asked, which of the two operations is the faster? The interesting fact is that this question allows us to answer the question as well: We have two equal indices except that one is unique Which of the two allows us to perform better? It's benchmark time men! ...It's benchmark time! ha ha ha! Enjoy! "Singleton_lookup Vs. Range_scan" & "Index Vs. Unique Index" To compare the speed of the two different access modes we use a com...