I have seen occasional mentions of using

SELECT COUNT(*) FROM myTable

To update the internal statistics... Is this true???

We have been performing a gbak backup and a gbak restore each night...
so I am curious if we need to be doing anything more to keep the
database in good shape.

I would like to know if I should be performing some additional tasks
and what the benefit would be.

This is not a huge db, but at least one table that has well over a
million records and a few other tables are close behind.

Thanks,
Raymond

--
Raymond J. Schappe
Isthmus Technology Solutions, LLC
______________________________________