Thread: pgsql: Remove item: < * Allow star join optimizations < < While our
pgsql: Remove item: < * Allow star join optimizations < < While our
From
momjian@postgresql.org (Bruce Momjian)
Date:
Log Message:
-----------
Remove item:
< * 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. Some
< of these algorithms might be patented.
Modified Files:
--------------
pgsql/doc:
TODO (r1.1733 -> r1.1734)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1733&r2=1.1734)
pgsql/doc/src/FAQ:
TODO.html (r1.238 -> r1.239)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.238&r2=1.239)