Ok, just to be sure its not because of DB performance issue, try to run the SQL fragmentation check and based on the result, try running some maintenance on DB
Here is the query that I have for MS SQL
SELECT db.name AS databaseName , so.name , si.name , ps.OBJECT_ID AS objectID , ps.index_id AS indexID , ps.partition_number AS partitionNumber , ps.avg_fragmentation_in_percent AS fragmentation , ps.page_count FROM sys.databases db INNER JOIN sys.dm_db_index_physical_stats (OBJECT_ID('CA_UIM'), NULL, NULL , NULL, N'Limited') ps ON db.database_id = ps.database_id inner join sys.sysobjects so on ps.object_id = so.id inner join sys.sysindexes si on ps.object_id = si.id and ps.index_id = si.indid WHERE ps.index_id > 0 AND ps.page_count > 100 AND ps.avg_fragmentation_in_percent > 30 AND db.Name = 'CA_UIM' order by ps.avg_fragmentation_in_percent desc