firefox-sqlite-vacuum-reindex.sh

DB=$1
if [ "x$DB" == "x"  -o ! -f "$DB" ]; then
  exit
fi

echo $DB
sqlite3 $DB 'vacuum'
  for i in `sqlite3 $DB .schema | grep -o 'INDEX [^ ]*' | sed -e 's/^INDEX \([^ ]*\)/\1/'`
do
echo $i
sqlite3 $DB "reindex $i"
done
echo ...$DB done.

# sqlite3 cookies.sqlite 'create index moz_cookies_hostindex on moz_cookies ( host)'