oleg_d
Active Member
Hi!
I have following problem with growing table F41021 in Oracle DB:
data - 3.5 Gb
indexes - 11Gb
So, I want to optimize indexes organization - delete odd indexes.
F41021 has couple (for example, because there are another indexes exist) indexes:
[ QUOTE ]
PRODDTA.F41021_2 on PRODDTA.F41021 (LIITM, LIMCU, LILOTN, LILOCN)
[/ QUOTE ] and
[ QUOTE ]
PRODDTA.F41021_6 on PRODDTA.F41021 (LIITM, LIMCU, LILOTN, LILOCN, LIPBIN)
[/ QUOTE ]
The difference is in one additional field in second index LIPBIN. For Oracle optimizer it will be the same for query's processing, if there will be only last index - it's satisfying for conditions with
[ QUOTE ]
"where LIITM=... AND LIMCU=... AND LILOTN=... AND LILOCN=..."
[/ QUOTE ] AND
[ QUOTE ]
"where LIITM=... AND LIMCU=... AND LILOTN=... AND LILOCN=... AND LIPBIN=..."
[/ QUOTE ] If I will drop first index in DB(not in JDE), will be some problems with work in JDE?
I've tested such variant on small test application and it seems to work fine, but I'm not sure about possible problems in JDE.
Can somebody help me in this situation?
Thanks.
I have following problem with growing table F41021 in Oracle DB:
data - 3.5 Gb
indexes - 11Gb
So, I want to optimize indexes organization - delete odd indexes.
F41021 has couple (for example, because there are another indexes exist) indexes:
[ QUOTE ]
PRODDTA.F41021_2 on PRODDTA.F41021 (LIITM, LIMCU, LILOTN, LILOCN)
[/ QUOTE ] and
[ QUOTE ]
PRODDTA.F41021_6 on PRODDTA.F41021 (LIITM, LIMCU, LILOTN, LILOCN, LIPBIN)
[/ QUOTE ]
The difference is in one additional field in second index LIPBIN. For Oracle optimizer it will be the same for query's processing, if there will be only last index - it's satisfying for conditions with
[ QUOTE ]
"where LIITM=... AND LIMCU=... AND LILOTN=... AND LILOCN=..."
[/ QUOTE ] AND
[ QUOTE ]
"where LIITM=... AND LIMCU=... AND LILOTN=... AND LILOCN=... AND LIPBIN=..."
[/ QUOTE ] If I will drop first index in DB(not in JDE), will be some problems with work in JDE?
I've tested such variant on small test application and it seems to work fine, but I'm not sure about possible problems in JDE.
Can somebody help me in this situation?
Thanks.