My Oracle Support Banner

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

Last updated on APRIL 24, 2023

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.