I am having a process which truncates and loads 1 million nightly. The feature class has an index applied . After my load completes the process rebuild index and analyzes the feature class. Rebuilding Index and Analyze dataset alone takes 1.5 hr .
I have compressed the database. Tried deleting and recreating the index. No change
I am sure something is not write. Can anyone point me how to identify the issue and solve it