Clearly, an index build on only one column of the
bit type is useless because the selectivity is poor (50% of a table in average). However, when a table has several columns of the
bit type, the composite index may be efficient.
For the test example, we'll create a table …