Category: indexing

How to get the array index or iteration number with an each iterator?

Post author By user user
Post date February 19, 2022
Categories In indexing, iterator, ruby
2 Comments on How to get the array index or iteration number with an each iterator?

I’m iterating through an array in ruby with each. Is there an easy way to get the iteration number or array index without going back to a for loop?

Declaring an Index as unique in SQL Server

Post author By user user
Post date February 19, 2022
Categories In indexing, performance, sql-server, unique
7 Comments on Declaring an Index as unique in SQL Server

If I know an index will have unique values, how will it affect performance on inserts or selects if I declare it as such. If the optimiser knows the index is unique how will that affect the query plan? I understand that specifying uniquenes can serve to preserve integrity, but leaving that discussion aside for […]