Grant,

Thank you for the information. Can you possibly point me to the right direction for updating stats on the tables as well as more information for "Full Scans". I will look this up on Google myself as well.

Also, can I update the statistics on these tables in Production during regular business hours? How much effect would updating the statistics have on the database load wise?

Thanks,

S