CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Table index rebuild & index fragmentation

edited Aug 14, 2020 1:13PM in CNC, DB and Operating System - JDE1 (MOSC) 4 commentsAnswered

Hi Team,

Can anyone help me to understand below topics / questions :

Table index rebuild & index fragmentation both are same or different?

Is it recommend to do the index rebuild for bigger table like F0911 ?

If Yes, can we use JDE application for rebuild or using Database side ?

Any performance degradation after performing index rebuild ?

Any negative impact of doing index rebuild for Big table ?

Any negative impact or performance degradation of doing index fragmentation ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center