1. A method to accelerate execution of a query on a federated database system, the federated database system being associated with an external data source, the query utilizing the external data source and being performed based upon a query execution plan, the method comprising: generating at least one optimizer query for the external data source utilized by the query, the optimizer query used in generating a future query execution plan, the at least one optimizer query being based on the query and obtains data related to the external data source, wherein the at least one optimizer query is generated by a federated server of the federated database system, and wherein the external data source is independent with respect to the federated server; providing the at least one optimizer query to the external data source to execute using the external data source; collecting at least one resultant from execution of the at least one optimizer query to use in generating the future query execution plan; analyzing the collected statistics to provide the future query execution plan; providing the future query execution plan, and wherein the step of generating at least one optimizer query further includes parsing the query to determine a portion of the query utilizing the external data source, and generating at least one optimizer query based on the portion of the query utilizing the external data source, and wherein the external data source utilizes at least one operator to execute the query, with the at least one optimizer query being used to determine the at least one resultant for the at least one operator.
1. A method to accelerate execution of a query on a federated database system, the federated database system being associated with an external data source, the query utilizing the external data source and being performed based upon a query execution plan, the method comprising: generating at least one optimizer query for the external data source utilized by the query, the optimizer query used in generating a future query execution plan, the at least one optimizer query being based on the query and obtains data related to the external data source, wherein the at least one optimizer query is generated by a federated server of the federated database system, and wherein the external data source is independent with respect to the federated server; providing the at least one optimizer query to the external data source to execute using the external data source; collecting at least one resultant from execution of the at least one optimizer query to use in generating the future query execution plan; analyzing the collected statistics to provide the future query execution plan; providing the future query execution plan, and wherein the step of generating at least one optimizer query further includes parsing the query to determine a portion of the query utilizing the external data source, and generating at least one optimizer query based on the portion of the query utilizing the external data source, and wherein the external data source utilizes at least one operator to execute the query, with the at least one optimizer query being used to determine the at least one resultant for the at least one operator. 6. The method of claim 1 wherein the at least one optimizer query further is configured to perform sampling on the external data source.