Jiwa

Hi,
During the migration testing for our client to 7.0.129 running on SQL 2008 R2 on Window server 2012 R2,
we found that the standard Jiwa Statement has been running very slow, so we ran the stored procedure to time it. The result only got returned after 19 minutes of running.
There must be issue with the SQL not using index properly, Do you have any solution to speed it up?

Try running update_all_stats stored procedure.

If that doesn't help it's probably, as you say, an index missing. Determining which index is missing can be done by comparing the indexes with the ones in demo data for the following tables:

• DB_Main
• DB_Trans
• DB_TransAlloc

If that still doesn't help, then you'll need to look at the query plan output to see where the time is being spent and we can offer further guidance then.