For now, clicks on a table, how can now article 1000 w data with 2.5 seconds in the 100 million data query efficiency?

CodePudding user response:

Attached SQL:



SELECT COUNT (1), ref_category_id
The FROM cms_content t, (SELECT content_id
The FROM rmp_content_click
WHERE view_time & gt; 00:00:01=to_date (' 2016-07-01 ', '- dd yyyy - mm hh24: mi: ss') AND view_time & lt; 23:59:59=to_date (' 2017-02-28 ', '- dd yyyy - mm hh24: mi: ss')
C)
WHERE Arthur c. ontent_id=tc ontent_id AND ref_category_id IN (784785868783867870781782800801802869871872873874875876877878879880881882883884886803)
GROUP BY ref_category_id;

CodePudding user response:

The index is also said;


PS: this table, want to consider partitions,