Hello, I am working on query time optimization on some data structures. I am recently working on multi dimensional queries. I am using cube to multi dimensions. I have a table in my database what named points and it has a column what named point. Point column has 10 dimensions. I can perform a database query as written below;
SELECT *
FROM points
WHERE point && CUBE(ARRAY[0, 0, 0, 0, 0, 0, 0, 0, 0, 0], ARRAY[15, 15, 15, 15, 15, 15, 15, 15, 15, 15]);
However, I want to perform this query by removing some dimensions from the query. When I search online and ask ai it seems the only solution is to set the minimum and maximum integers of the columns I want removed from the query. But this effect the performance of query time. Just as we do not include some columns in the query when querying an ordinary database table, here too I do not want to include some dimensions in the query. In this way, I want to get rid of the query load of dimensions that I do not include in the query. Is there a way I can perform queries this way?
Note: I will use the findings here for a scientific study.
