jimmymac
Reputable Poster
We are on E1 9.0, tools release 9.1.4.7, oracle 11g database.
My question is around adding a new index to a standard JDE table. For performance reasons related to a new process, we may need to add a new index to the F0411. It seems though that when you go into the FDA and add a new index, the only option in OMW appears to be the Generate Indexes, which would rebuild all indexes over the F0411. Is there a way in JDE to only generate a specific index, such as the new one I've just added.
I really don't want to have all of the existing indexes recreated, I would think there would be a way to generate just a specific index.
Any ideas would be appreciated. Thanks.
My question is around adding a new index to a standard JDE table. For performance reasons related to a new process, we may need to add a new index to the F0411. It seems though that when you go into the FDA and add a new index, the only option in OMW appears to be the Generate Indexes, which would rebuild all indexes over the F0411. Is there a way in JDE to only generate a specific index, such as the new one I've just added.
I really don't want to have all of the existing indexes recreated, I would think there would be a way to generate just a specific index.
Any ideas would be appreciated. Thanks.