After INDEX

Hi all,

I applaied a INDEX on a database with big table (8.000.000 recors) , my question is: If I act a Backup and after Restore this backup I will obtain a increase of performance, in other words on Restore of database is included a re-organization of INDEX.

sorry for my question but I need to know before try.

Thanks a lot

Hid

Yes, restored database will include re-orgnization of the index.

When you take the backup it includes everything at that point and restore will not change anything...