Table with big volume of data - Need for optimization
I would like to display a simple table (i.e. 5 columns), but with millions of lines. I would like to have a condition on one of the column. Unfortunately, the performance are not good and I am seeking help for optimization.
I would like to display all the Sales made this year. Here's my table:
I suspect that having the field "if(SaleYear= year(today()), SaleID)" as a dimension in the column of the table degrades the performance. Would you have any recommendation in order to improve the response time?