Milimetric has submitted this change and it was merged. Change subject: Add SQL script to create indexes in EL Edit tables ......................................................................
Add SQL script to create indexes in EL Edit tables Bug: T89256 Change-Id: Ic0147336e88429c234b3c9f6d99fd504ae1b6d3e --- A analytics-store/log/Edit_10676603_indexes.sql 1 file changed, 11 insertions(+), 0 deletions(-) Approvals: Milimetric: Verified; Looks good to me, approved diff --git a/analytics-store/log/Edit_10676603_indexes.sql b/analytics-store/log/Edit_10676603_indexes.sql new file mode 100644 index 0000000..efa3986 --- /dev/null +++ b/analytics-store/log/Edit_10676603_indexes.sql @@ -0,0 +1,11 @@ +-- This script creates indexes for EventLogging Edit_10676603 table +-- to speed up scheduled queries, including funnel data extraction. +-- See related task: https://phabricator.wikimedia.org/T89256. + +CREATE INDEX ix_Edit_10676603_event_action + ON Edit_10676603 (event_action) + USING HASH; + +CREATE INDEX ix_Edit_10676603_event_editingSessionId + ON Edit_10676603 (event_editingSessionId) + USING HASH; -- To view, visit https://gerrit.wikimedia.org/r/190404 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ic0147336e88429c234b3c9f6d99fd504ae1b6d3e Gerrit-PatchSet: 3 Gerrit-Project: analytics/data-warehouse Gerrit-Branch: master Gerrit-Owner: Mforns <[email protected]> Gerrit-Reviewer: Milimetric <[email protected]> Gerrit-Reviewer: Nuria <[email protected]> Gerrit-Reviewer: Springle <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
