On Tuesday 12 April 2011 01.02:35 Lucas Cotta wrote:
> Does postgre execute the queries following a execution plan tree, where
> the leafs are table scans, and the nodes are joins?
yes, see the "EXPLAIN" SQL command (EXPLAIN SELECT * FROM ), it will
shwo this tree.
http://www.postgresql.org/
Hi!
Does postgre execute the queries following a execution plan tree, where the
leafs are table scans, and the nodes are joins?
I'm looking for a database where I can get a cardinality from a partial
result of the execution... for example, print the cardinality of the results
until the next join
Hi!
Does postgre execute the queries following a execution plan tree, where the
leafs are table scans, and the nodes are joins?
I'm looking for a database where I can get a cardinality from a partial
result of the execution... for example, print the cardinality of the results
until the next join