- match(m: 08-day details of station area electricity consumption) where id(m)==‘1001020230802distStatDay’ return m soon
- match(m: 08-day details of station area power consumption) where id(m) contains '20230802' return m is very slow
- match(m: details of electricity consumption in Taiwan area on 08th) where m. details of electricity consumption in Taiwan area on day 08. date==‘20230802’ return m is very slow
Environmental profile:
- Sufficient resources;
- The electricity consumption of the station area on 08th is detailed, there are 1.8 million data under this tag, and the date is an index;
Query target: If you want to query all the data of the day 20230802, it is very slow to use the second and third statements to query, but it is very fast to use the first statement to query the data under a single index. I would like to ask how to quickly find out the data of the day 20230802 .
