Hi, As I have mentioned on the list on the past... UPDATE STATISTICS requires lots of slow disk I/O and it locks the tables. Some of our tables are large and the lock can last for long periods (30 minutes or longer for a single table). Yes, this is on professional 15,000 RPM SCSI hard drives. My question... I'm assuming that UPDATE STATISTICS is doing is changing some internal pagecount or otherwise. We have 3 servers all running with copies / replicas of the same database. Is it possible that we could run UPDATE STATISTICS on only one server and duplicate the results to the other two servers? On a related note, if I use loadercli to populate a database that was sourced from "TABLEXTRACT PAGES" - do I have to run UPDATE STATISTICS to get it correct - or is that brought over with the extracted table? The UPDATE STATISTICS seems to take longer than loading the data itself :) Thank you. Stephen Gutknecht -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
