Thanks Andres, > 1. Since the value of geqo_threshold is 12, does the geqo get
automatically
> activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact that even a predefined order like:
a JOIN b
On Thursday 16 July 2009 09:02:53 Ms swati chande wrote:
> 1. Since the value of geqo_threshold is12, does the geqo get automatically
> activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact th
Hi,
I have a few queries on the use of the geqo.
1. Since the value of geqo_threshold is12, does the geqo get automatically
activated for queries with 12 or more joins?
2. Can the geqo threshold be set to a smaller value like 4 or 5?
3. How do we come to know whether the geqo has been used to
