Patent ID: 8577870

Claim:
A method of obtaining data from a multi-tenant database, the method comprising: modifying a development database representative of the multi-tenant database based on expected utilization information for a tenant supported by the multi-tenant database; generating model database statistics based on the development database after modifying the development database, wherein generating the model database statistics comprises: obtaining a subset of database statistics determined by a database management system of the development database after modifying the development database; creating the model database statistics having values representative of an anticipated state of the multi-tenant database based at least in part on the obtained subset of the database statistics determined by the database management system of the development database; and providing the model database statistics to the multi-tenant database by modifying on-demand database statistics maintained by the multi-tenant database to reflect the model database statistics, a query optimizer of the multi-tenant database generating a query plan based on the on-demand database statistics, wherein the query plan generated by the multi-tenant database to obtain the data is influenced by the model database statistics.