1. A database system capable of dynamically creating one or more keys associated with one or more pre-compiled queries, the system comprising: a query module operating to generate one or more pre-compiled queries from a query representation received from a client; a plurality of slave nodes operating to execute the one or more pre-compiled queries, each of the plurality of slave nodes operating to track, as the one or more pre-compiled queries are executed over a time period, one or more usage statistics identifying variables used to resolve the pre-compiled queries on each slave node; and at least one master node coupled to each of the plurality of slave nodes, the at least one master node comprising a computer processor and operating to: receive the one or more usage statistics from each of the plurality of slave nodes, compute, based on the respective usage statistics from each slave node, a number of times the identified variables were used as the pre-complied queries were executed over the time period, and, based at least in part on the number of times the identified variables were used during the time period, request the plurality of slave nodes to dynamically create one or more keys, the keys including pointers identifying locations of data on the slave nodes for resolving the pre-compiled queries; wherein each of the plurality of slave nodes dynamically creates the one or more keys for use in executing the one or more pre-compiled queries.