SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo

Save space in indexes when the leading columns have duplicates with ALTER INDEX ... REBUILD COMPRESS n => deduplicate the first N columns But what is the best value of N? David Kurtz finds it with ANALYZE INDEX … VALIDATE STRUCTURE CASCADE blog.psftdba.com/2025/07/optima…