The result – indexes now have pages where logical ordering (based on the key-value) differs from the physical ordering inside the data file. More on CREATE INDEX Transact-SQL can be found on the MSDN.Īfter indexes are created, they will undergo automatic maintenance by the SQL Server Database Engine whenever insert, update or delete operations are executed on the underlying data.Įven so, these automatic modifications will continuously scatter the information in the index throughout the database – fragmenting the index over time. CREATE INDEX MyIndex ON MyTable (Column1 )
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |