• If your table is truly static and you have the space then add as many indexes as you need to cover the queries being issued. Go ahead and use a FILL_FACTOR of 100 (or 0) too. Another thing you can do to help performance is to move the table and its indexes to a new FILEGROUP and then mark the FILEGROUP as read-only.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato