Hi,
I have checked the indeces, the query is optimised. I have also done the xref to check which index query is using and any "whole-index"..everything seems to be ok.
This is actually for a call center and everytime clients/users call a record is created.
The table is called "call_hist", we...