Here are some things you can do to make your queries run faster:
1️⃣ Reduce the size of your data set by adding an early filter.
Try adding your filter steps as early in the query steps as possible. E.g. apply a filter on the date range, to look at data from just the last few days / weeks / months.
2️⃣ Ask your database owner / admin to add indexes.
This is a data structure that improves the speed of data retrieval operations.
3️⃣ Ask your admin to give your database more memory
This will help if your database tends to get overloaded.
Please sign in to leave a comment.