SQL query i staking forever to run and not loading at all. Using a parallelism of 4, I am able to make it load but when I run OEM adviser, it is suggesting a functional index that already exists. When I go to create the suggested index anyway, it says it already exists.
Index it is suggesting:
Index that already exists: generated a DDL for existing index one.
CREATE UNIQUE INDEX "BAAN"."TTCIBD001100$IDX1" ON "BAAN"."TTCIBD001100" (NLSSORT("T$ITEM",'nls_sort=''UCA0700_DUCET_S4_VS_BN_NY_EN_FN_HN_DN_MN''')) TABLESPACE "LN100_INDEX" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) NOLOGGING
Any help would be greatly appreciated.