This website uses cookies to ensure you get the best experience.
Learn more.
After a large load and many deletes, a Redshift table shows poor query plans and substantial reclaimable space. Automatic maintenance has not resolved the issue within the required window. Which statement best distinguishes the manual maintenance operations to evaluate?
Published
- A table rename refreshes all optimizer statistics and reclaims deleted-row storage.
- ANALYZE permanently removes every deleted row and VACUUM only records column aliases.
- ANALYZE updates optimizer statistics, while an appropriate VACUUM operation can address applicable sorting or deleted-row space-reclamation needs.
- A SELECT LIMIT 1 updates statistics for every table and compacts all deleted data.
Comments — 0
Sign in to comment