Advertising

SELECT
mid,
COUNT (*),
string_agg (
create_time ,|| '#' || s_id
ORDER BY
create_time
)
FROM
t1
WHERE
t1.create_time BETWEEN to_timestamp(
'2016-12-19 00:20:00:770',
'yyyy-MM-dd HH24:MI:ss.ff'
)
AND to_timestamp(
'2016-12-19 23:40:00:770',
'yyyy-MM-dd HH24:MI:ss.ff'
)group by mid;
when we explain the sql statement, we find it scan all the partition of table
t1 in the query plan, and it has a huge impact on the query performance.
what can i do to solve this problem?
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)