I've written one script for fetching all the table and then individual table row count. One part of the script is below :
=========================================================
for i in `grep -v "tabname" "${DIR}/t_tab1"`
do
cnt2=`expr $cnt2 + 1`
cnt=`echo "SELECT COUNT(*) FROM $i " | dbaccess ${DBNAME}`
echo $i " "$cnt >> $FILE1
if [[ $count1 -eq $cnt2 ]]
then
break
fi
done
=========================================================
I run the script in Test server in running well, and now I need to move in Production.
As multiple times script making connection with database and fetching count from table, So do I need to run UPDATE STATISTICS LOW before running this script.
Already there are multiple UPDATE STATISTICS running on few table with Medium and High mode. So if I run UPDATE STATISTICS LOW , will it impact all running UPDATE STATISTICS put on table?
Kindly suggest.
Thanks
Amit
------------------------------
AMIT PATEL
------------------------------
#Informix