O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index Maintenance

SQL Server automatically maintains indexes on tables. Every INSERT, UPDATE, or DELETE operation forces SQL Server to update the index information to keep it up to date. This maintenance produces some overhead on these operations.

Any time you insert a new row and you had a clustered index, SQL Server must search for the correct page to insert this new row. If the page is full, SQL Server decides the best way to insert this row, depending on the following conditions:

  • If the row has to be inserted at the end of the table and the last page doesn't have any free space, SQL Server must allocate a new page for this new row.

  • If the row has to be inserted into an existing page and there is enough free space in the page to allocate this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required