GIN as a substitute for bitmap indexes This is an off-site link.  Please review our Terms of Service for additional information.

(Heikki Linnakangas) On some other DBMS’s, bitmap indexes are often used for columns that have only a few distinct values. Boolean columns, status codes and such. Compared to normal B-tree indexes, bitmap indexes are very efficient at packing duplicates.

Read this article...

comments powered by Disqus