Gabriel39 opened a new pull request, #41789: URL: https://github.com/apache/doris/pull/41789
## Proposed changes `SELECT h1.UserID, h2.URL, COUNT(*) AS visit_count FROM (SELECT * FROM hits_10m LIMIT 5000) AS h1 CROSS JOIN (SELECT * FROM hits_10m LIMIT 5000) AS h2 GROUP BY h1.UserID, h2.URL ORDER BY visit_count DESC LIMIT 1000;` before: 1 min 17.79 sec after: 16.73 sec <!--Describe your changes.--> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
