Block Range Index
Database indexing technique / From Wikipedia, the free encyclopedia
Dear Wikiwand AI, let's keep it short by simply answering these key questions:
Can you list the top facts and stats about Block Range Index?
Summarize this article for a 10 year old
A Block Range Index or BRIN is a database indexing technique. They are intended to improve performance with extremely large[lower-roman 1] tables.
BRIN indexes provide similar benefits to horizontal partitioning or sharding but without needing to explicitly declare partitions.[1]
A BRIN is applicable to an index on a table that is large and where the index key value is easily sorted and evaluated with a MinMax function.[lower-roman 2]
BRIN were originally proposed by Alvaro Herrera of 2ndQuadrant in 2013 as 'Minmax indexes'.[2] Implementations thus far are tightly coupled to internal implementation and storage techniques for the database tables. This makes them efficient, but limits them to particular vendors. So far PostgreSQL is the only vendor to have announced a live product with this specific feature, in PostgreSQL 9.5.[3][4] Other vendors have described some similar features,[2] including Oracle,[5][6] Netezza 'zone maps',[7] Infobright 'data packs',[8] MonetDB[9] and Apache Hive with ORC/Parquet.[10]