Posted by: Clifford W. Bass
Hello,
My wish for today: Please place an explicit "UPDATE STATISTICS ON
DATABASE;" line in the database unload file prior to the storing of any
commands and the creation of any views.
The reason: The past few times that that I have done an unload and
reload in version 9.x I have noticed a distinct slowing down of the
execution of stored commands after an unload. If I do a load using the
unload file as created by the unload it takes 1.92 seconds to execute the
following stored command specifying a table with 236 columns. If I add the
update statistics command into the unload file prior to the view creation,
which is prior to the storing of the commands, it takes 0.01 seconds. The
difference is noticible with other (all?) stored commands.
store SysAdm.GetColumns
select distinct LowName = @lower(T2.Name)
from SysAdm.SysSynonyms T1, SysAdm.SysColumns T2, SysSQL.SysTabAuth T3
where T2.TbCreator = T1.TbCreator and T2.TbName = T1.TbName and TCreator =
T1.TbCreator and TtName = T1.TbName and ((T1.Creator =
USER and exists (select * from SysAdm.SysSynonyms T4 where T4.Creator =
USER and T4.Name = @upper(:1))) or (T1.Creator = 'PUBLIC' and
not exists (select * from SysAdm.SysSynonyms T5 where T5.Creator = USER
and T5.Name = @upper(:1)))) and T1.TbName not like 'SYS%' and
SelectAuth = 'Y' and T1.Name = @upper(:1)
order by 1;
Thank You,
Clifford Bass