DYNAMIC CREATION AND MAINTENANCE OF MULTI-COLUMN CUSTOM INDEXES FOR EFFICIENT DATA MANAGEMENT IN AN ON-DEMAND SERVICES ENVIRONMENT

摘要

In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamic creation and maintenance of multi-column custom indexes for efficient data management in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method includes receiving multiple custom fields associated with an application running at a computing device, where the multiple custom fields are received in a specified sort order. The method further include dynamically building multi-column indexes of the multiple custom fields of multiple intrinsic datatypes stored in a same physical column of a shared table, where the multiple intrinsic datatypes are converted into a generic-indexable datatype that preserves the specified sort order. The method may further include building a sorted index in a specified order in a multi-column indexable table, where the multi-column indexable table includes a partial copy of data from multiple tenants that inhibit the shared table.