Monthly Archives: June 2014

3 Points about Indexes and Order

Oren Nakdimon 2 Replies

When dealing with indexes, order may be very significant, in several aspects. Perhaps it’s not surprising after all when talking about a data structure that its purpose is to keep data in order… We’ll refer to three different points: 1. Is the order of columns in a composite index important? 2. Which order is better: […]

Continue reading

One Problem – Many Solutions

Oren Nakdimon 1 Reply

One of the things I love in the SQL language is that one problem may have many different solutions, or more specifically, one functional question may be solved by different SQL queries. It doesn’t mean that all the solutions are equivalent in all aspects. If all the solutions solve the functional question correctly, then all […]

Continue reading