Databases handle thousands or even millions of records, and they need to be able to return results in milliseconds. Thus, it is imperative to optimize data fetching: indexes. This article explains indexes and how to implement them in OutSystems.

A data migration might be a long and painful process, and if you are here, it’s probably because you’re one of the lucky few that will have a taste. So, you have come to the right place; we are here to help!

To show you how you can optimize your queries to fetch only the records you want or how to apply some logic to manage heavy tables, let’s go on a trip where we’ll visit our beloved aggregates and, the ones feared by many, SQL queries.