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
 


      

Reply via email to