Previous Topic: ALTER CONSTRAINT StatementNext Topic: ALTER TABLE Statement for Adding a Default Index

SQL › Adding a Default Index

Adding a Default Index

A new option in the ALTER TABLE statement enables you to add a default index to an existing table. Adding a default index can improve performance when accessing the table or making additional definitional changes.