Grant Permissions and Update Statistics for Procedures

Hi, Informix 7.30.uc5 on Solaris 2.6, E10k. Does anyone know why you would need to run 'update statistics for procedures' after you grant table privileges to a new user in an Informix database? I'm been told by some dba's on a project that I just starting supporting that they were told that they had to run the 'update statistics for procedures' after granting new permissions to a new userid. They are not sure why they were told to do this. Any info. would be appreciated. -- Thanks, Melvin Mariney Sent via Deja.com http://www.deja.com/

melvin wrote in message <95n9ih$m3e$1@nnrp1.deja.com>... > >Does anyone know why you would need to run 'update statistics for >procedures' after you grant table privileges to a new user in an >Informix database? I'm been told by some dba's on a project that I just >starting supporting that they were told that they had to run >the 'update statistics for procedures' after granting new permissions >to a new userid. They are not sure why they were told to do this. > Someone who actually knows what they are talking about may correct me on this, but I have read that in general, the optimisation and permission checking of stored procedures is so complicated, Informix decided to merely mark SP's as dirty (therefore requiring fresh statistics) whenever something somewhere is changed that may remotely affect the stored procedures. This theory was picked to simplify development of the engine. Perhaps if it's a design goal or someone's pet project at Informix, this situation may be steadily improving, so possibly the advice is less relevent today. Have you noticed a problem if you DON'T update stats? I think my theory may be backed up by the disappearence of SP stat records from the statistics tables. You could have a bit of fun tracking that down to see if the engine clears them out whenever it thinks the SP's are dirty, and under what circumstances.