Rebuilding Table Indexes

  • Thread starter Thread starter Joe K.
  • Start date Start date
J

Joe K.

I have a MS-Access database that has 20 tables. Each table has several
indexes.
Is there away to rebuild like SQL Server?

Please help me with this task.
 
You can use VBA code or DDL queries (just like in SQL-Server) to drop and
recreate indexes. There is usually no advantage to that because compacting
rewrites everything anyway.

The only time it is really advantages to drop and rebuild indexes is when
there are very large amounts of data to append to a table. Dropping the
index allows the import to go much faster.
 
Back
Top