Statistics mechanisms in multitenant database environments

摘要

Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.

主权项

1. A method comprising:
maintaining a master statistics file in a multitenant environment, the master statistics file having statistics corresponding to multiple tenants within the multitenant environment; parsing the master statistics file into an object having an ordered grouping of statistical information corresponding to one or more selected tables stored in a single database within the multitenant environment; generating statistics for a table, the table corresponding to a selected tenant of the multitenant environment, the table from the one or more selected tables; and updating the master statistics file based on the generated statistics for the table.