This file is indexed.

/usr/share/doc/firebird2.5-common-doc/examples/reindex-db is in firebird2.5-server-common 2.5.1.26351.ds4-2build1.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
#!/bin/sh

set -eu

usage()
{
    cat <<"_EOF" >& 2
Usage: `sh basename $0` database
_EOF
    exit 1
}

[ -n "${1:-}" ] && [ -z "${2:-}" ] || usage

DB="$1"

ISQL=isql-fb

reindex()
{
    echo "Refreshing indices of '$DB':"
    while read i; do
        echo -n " $i"
        echo "ALTER INDEX $i ACTIVE;" | $ISQL "$DB" \
        || echo "ALTER INDEX $i ACTIVE;" | $ISQL "$DB"
    done
}

TMP=`tempfile`

trap "rm -f $TMP" QUIT INT EXIT

cat <<'EOF' | $ISQL "$DB" | perl -ne 's/ +$//; next if /^=*$/; next unless $start++; print' > $TMP
SET heading;
SELECT DISTINCT i.rdb$index_name
FROM rdb$indices i
JOIN rdb$relations r
  ON r.rdb$relation_name=i.rdb$relation_name
JOIN rdb$index_segments s
  ON s.rdb$index_name=i.rdb$index_name
JOIN rdb$relation_fields f
  ON f.rdb$relation_name=i.rdb$relation_name
JOIN rdb$fields fd
  ON fd.rdb$field_name=f.rdb$field_source
JOIN rdb$character_sets cs
  ON cs.rdb$character_set_id = fd.rdb$character_set_id
WHERE fd.rdb$field_type IN (14,15,37,38,40,41)
  AND (i.rdb$index_inactive=0 OR i.rdb$index_inactive IS NULL)
--  AND (r.rdb$system_flag=0 OR r.rdb$system_flag IS NULL)
  AND cs.rdb$character_set_name NOT IN ('NONE', 'OCTETS');
EOF

sleep 1

reindex < $TMP