• Grasshopper, have you done any performance checks on things like;

    Select count(*) where bitfield1 = 1 and bitfield2 = 0 and bitfield3 = 1 and.... for up to 64 bits?

    What is the impact of indexing 64 bit columns as far as size, speed, reads etc.

    As per your comments, for a single bit field it takes 2000 reads.

    Phil