Index Naming Conventions

Indexes are named the same as the table on which they are created plus a one-character to four-character suffix, see the following table.

Suffix	Value	Unique or Not Unique
_F#	Foreign key index.	Not unique
_II	Index on INTEGRATION_ID columns that are used for integrating Siebel Business Applications with back-office applications.	Not unique
_P#	Primary key index.	Unique
_U#	Primary key index of the user.	Unique
_V#	Special routing visibility rule index; usually on primary child foreign key and system foreign key columns not ordinarily indexed (for example, primary address, primary contact, creator, and so on).	Not unique
_M#	Miscellaneous index. Any index that does not fit into one of the previous categories.	Not unique

Caution: Before modifying or deleting indexes, create a service request (SR) on My Oracle Support. Modifying or deleting indexes can negatively affect the performance of Siebel Business Applications and can render the applications unusable. Alternatively, you can phone Global Customer Support directly to create a service request or get a status update on your current SR.