Hi, While trying out query executions using the geqo, I could not understand the following output. The geqo paramaters are set to default values. (pool_size=0). When the pool_size and the worth of the plans was displayed, the following values were obtained, irrespective of the number of relations in the query. For a query with 50 relations: GEQO selected 250 pool entries,
best 8385954963095356800000000000000000000000000000000.00,
midvl 8385954963095356800000000000000000000000000000000.00,
worst 8385954963095356800000000000000000000000000000000.00. For a query with 20 relations: GEQO selected 250 pool entries,
best 45771829382598713000.00,
midvl 45771829382598713000.00,
worst 45771829382598713000.00. For a query with 15 relations: GEQO selected 250 pool entries,
best 6801044405876.81,
midvl 6801044405876.81,
worst 6801044405876.81. Please help me understand this. Regards Swati |