Index on ID column For Table VMVISITOR? (Doc ID 2188473.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Goal

My DBA has recommended to create an index for table VMVISITOR and column IDENTIFIER (create index id1 on VMVisitor(to_number(id)) compute statistics). Is there any problem? Can I create this index? Should this index exist?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms