Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian2005-12-17 16:43:11 +0000
committerBruce Momjian2005-12-17 16:43:11 +0000
commit9e9a844f551249d4594894f683a5f0a1d9b73431 (patch)
treeb03f4c5d0003929b83f5a11012e638ae53e96e1b /contrib/btree_gist/sql
parent927f57687ffb4afba0b394580d314dedefbdbee6 (diff)
Add:
* Allow star join optimizations While our bitmap scan allows multiple indexes to be joined to get to heap rows, a star joins allows multiple dimension _tables_ to be joined to index into a larger main fact table. The join is usually performed by either creating a cartesian product of all the dimmension tables and doing a single join on that product or using subselects to create bitmaps of each dimmension table match and merge the bitmaps to perform the join on the fact table.
Diffstat (limited to 'contrib/btree_gist/sql')
0 files changed, 0 insertions, 0 deletions