[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Last time UPDATE STATISTICS was run?

Status
Not open for further replies.
D

dbeavon

Guest
>> Changes should be made only via use of the UPDATE STATISTICS functionality. Yes I agree. But once the DBA starts down the path, they become responsible for making a lot of discretionary choices about *what* tables and indexes and columns need statistics, and how *frequently*, etc. All of this involves changes to the internal statistics-related data, and all is prone to human error. Ideally the DBMS itself should be responsible for it and not a human operator. ... and did you see @kirchner's comment above that shows how DBA's can also *delete* statistics when needed? That's another nice feature for DBA's to use when they want to shoot themselves in the foot. There is also a KB about how to manage the data in these internal tables, eg. by deleting it or even backup/restoring the data: knowledgebase.progress.com/.../000031799 All I'm saying is that in general this stuff shouldn't be a DBA's responsibility, except in extremely unusual circumstances. It will be a welcome change when OE 12 takes responsibility for this stuff.

Continue reading...
 
Status
Not open for further replies.
Top