Is rebuilding of database indexes reflected in the .bak file?

140 Views Asked by At

I have used the following query in my local computer to rebuild an INDEX on a table of database. After that I have created a .bak file to move the database to the server. I am not sure if rebuilding an INDEX is reflected into the .bak file or it is just a defragmentation process on the local HARD DISK?

USE MYDB;
GO
ALTER INDEX PK_Titles ON NEWS
REBUILD;
GO

Should I repeat this query on the server again?

0

There are 0 best solutions below