Pesquisar

Can I add an index to a custom object?

Environment:

Custom Objects
Oracle B2C Service, All Versions

Resolution:

An index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed.

To add an index to an custom object, please follow the steps below:

1) Log into the console

2) Under Configuration, expand the Database folder and open Object Designer

3) Select the custom object you want to add the index

4) In the ribbon select "Fields".

5) Then, in the new page-> "Add New Field"

6) Select the type you want to the index

7) Then check the box "Is In Single Field Index"

8) Deploy the custom object

Option:  Is In Single-Field Index - Select this option to add an index entry for the field in cases where the field is the only field in the index. To add a multiple-field index, click the Indices button on the ribbon. Refer to step 14 in the procedure to create a custom object. This option is available only for fields with Date, Date/Time, Integer, or Text data types.

For additional information on the impact of adding indexes please review Answer ID 1266: Impact of indexing a custom field.

For information regarding common situations in which to add indexes please review Answer ID 4494: When to index a custom field.