Thanks, we are using that script doing maintenance of db, but only on weekend.

Now that reminds me another related question, we have a process nightly to create some tables in a database then import data into tables, then add indexes, pks, fks, then restore the database on another sever B

People use serverB to query, create excel reports. The above process is done nightly. So does that mean the indexes never been rebuilt? If so I wonder why not hearing much complain of the query running slow?