4 ms·
Sure you can do a binary OR but you need to examine all of the data in the table which effectively becomes a full table scan. The beauty of indices is that you
by bognition 4y ago
Sure you can do a binary OR but you need to examine all of the data in the table which effectively becomes a full table scan. The beauty of indices is that you only need to scan a subset of the data to find the information you're looking for.
- withinboredom 4y agoYou can store columns for each bit in the filter, so a binary OR wasn’t a full table scan, just an index lookup for certain columns.