GL table indexes recommendations
We are advised that the following indexes will help EBS GL performance and I would like your input on pros/cons on implementing these recommendations?
-- for improving performance related to GLXJEENT the following is recommended:
create index GL.GL_JE_BATCHES_N55 on GL.GL_JE_BATCHES("CHART_OF_ACCOUNTS_ID","PERIOD_SET_NAME","ACCOUNTED_PERIOD_TYPE","NAME");
create index GL.GL_JE_HEADERS_N55 on GL.GL_JE_HEADERS("JE_BATCH_ID"+0);
create index APPS.GL_ACCESS_SET_LED_N55 on APPS.GL_ACCESS_SET_LEDGERS("ACCESS_SET_ID","LEDGER_ID");
-- for improving performance relating to GLPPOSS the following is recommended:
-- for improving performance related to GLXJEENT the following is recommended:
create index GL.GL_JE_BATCHES_N55 on GL.GL_JE_BATCHES("CHART_OF_ACCOUNTS_ID","PERIOD_SET_NAME","ACCOUNTED_PERIOD_TYPE","NAME");
create index GL.GL_JE_HEADERS_N55 on GL.GL_JE_HEADERS("JE_BATCH_ID"+0);
create index APPS.GL_ACCESS_SET_LED_N55 on APPS.GL_ACCESS_SET_LEDGERS("ACCESS_SET_ID","LEDGER_ID");
-- for improving performance relating to GLPPOSS the following is recommended:
0