Timeline for Improving sql query execution time for 3 billion rows table
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 26, 2021 at 15:01 | comment | added | Rick James | @user134132523 - Reindexing would be terribly inefficient. Please provide an index that you perceive needs to be "reindexed", together with the query that needs that index. (I perceive that you have understood why the indexes will no longer be needed.) | |
| May 26, 2021 at 9:23 | comment | added | user134132523 | "Once you have built the summary table(s), you can and should drop the unnecessary indexes; " But If I need to update the summary table.. weekly or monthly, WIth this approach I would need to re index the large table right? this does not sound very efficient since it takes hours to index the large table | |
| May 25, 2021 at 18:30 | history | edited | Rick James | CC BY-SA 4.0 |
added 1076 characters in body
|
| May 25, 2021 at 18:16 | history | answered | Rick James | CC BY-SA 4.0 |