Sven Koehler wrote: > as far as i know, i must run "update stat *" regularly so that the > optimizer recognized changes in table-size etc. > > does this statement "block" any other operations on the table that is > currently "updated" or does the update execute concurrently?
update statistics is a non blocking operation for parallel update, insert, delete and select statements on the same table. Only parallel update statistics on the same table are blocked. Best regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
