Slide 30
Slide 30 text
30
ɹɹʛɹɹ© PLAID Inc.
νϡʔχϯάϙΠϯτ
2023.07.07ɹɹʛɹɹTiDB User Dayɹɹʛɹ
EXPLAIN
WITH filtered_events AS
(
SELECT
event_hash, user_hash
FROM
event_xxx event
WHERE
view_uri_url LIKE '%hoge%'
ORDER BY
sync_date DESC
LIMIT 10
)
SELECT
event.*, user.*
FROM
filtered_events
JOIN
event_xxx event
ON filtered_events.event_hash = event.event_hash
JOIN
usersummary_xxx user
ON filtered_events.user_hash = user.user_hash
ORDER BY
sync_date DESC
avg 682ms