Re:update statistics problem

Why after running 'update statistics high' performance of my application decrease dramatically? Anna Zygmunt

Anna Zygmunt wrote: > > Why after running 'update statistics high' performance > of my application decrease dramatically? I dunno. Phase of the moon? Post: Query text from the app that you suspect is slow (or tested slow in dbaccess) sqexplain.out sections for the query(s) above. dbschema -d databasename -hd tablename for each table in the query(s) above. dbschema -d databasename -t tablename for each table in the query(s) above. onstat -p onstat -P | tail -10 ONCONFIG file Then we'll have something to look at. Art S. Kagel