Hi Jeff,

Thanks for the reply.

The sample query that I've given was identical to the queries used on the 3 dataset, I just changed the tables and column names....

Hi Grant,

Thank you for your reply again, sorry but I can't give the actual query of the 3 dataset, I can only provide a sample. The report was made...

Hi Grant,

Thank you for the reply.

As for this one, it has only 1 column where clause that gets the...

Hi Jeff,

Thank you for the reply, we checked the tables and it has indexes on primary key and foreign keys(also keys that will be used on other searching). The...