Speed up slow queries

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. 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.