Re: ACE report - Help??

Quoting ihor.j.kinal... > > The only work around is to run update statistics on each table > in the db. This does not lock the entire db. [What I do > is query for each non system table, put that into a list, > and create an 'update statistics for table NAME;" for each NAME. > This is a little script that I whipped up that does pretty much the same thing. The only exception is it doesn't require anything more than just typing in the command. Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip : # update_em # Run UPDATE STATISTICS on a table by table basis # DATABASE=$1 if [ -z "$DATABASE" ] then echo "usage: update_em dbname" >&2 exit 1 fi isql $DATABASE - <<EOF 2>/dev/null | isql $DATABASE - output to pipe "cat" without headings select "update statistics for table ", tabname, ";" from systables where tabid >= 100 order by tabname; EOF exit 0 Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.6 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com