Indexes are a very important part of databases and are used frequently to speed up access to particular data item or items. So before working with indexes, it is important to understand how indexes work behind the scene and what
A collection of 4 posts
On Covering Indexes and Their Impact on Performance
The purpose of this post is to describe what covering indexes are and how they can be used to improve the performance of queries. People mostly use indexes to filter or sort the results but not much thought is given
Databases: Normalization or Denormalization. Which is the better technique?
This has really been a long debate as to which approach is more performance orientated, normalized databases or denormalized databases. So this article is a step on my part to figure out the right strategy, because neither one of these
Performance tuning using vertical partitioning
Does having small data-sets really help? Of course it does! Are memory lookups faster that disk lookups. Of course ! So many times I have seen people complain about queries taking too long now, while they were not taking that long
Subscribe to ovais.tariq - tech and leadership
Subscribe today and get access to a private newsletter and new content every week!