Hi all,
Due to performance issues in our data loads ,We observed that dropping and recreating the index for the table in the database improved our data load performance significantly.Original time -2 hrs ,after recreating the index -loads ran in 3 mins.It activity is take care by the DBA on demand .we are trying to execute the same using befimport jython script.Please help us by providing a sample code for dropping the index
DROP INDEX [TDATAMAP_T_U1] ON [dbo].[TDATAMAP_T], DROP INDEX [TDATASEG_T_U1] ON [dbo].[TDATASEG_T]
We were going through the manual for executing the DML,the following parameter needs to be called int executeDML(String query,Object[] parameters)-Correct us if we are wrong