Hello All,

I have an performance issue, where a query which is executed at the client place which is retrieving 370 records is taking around 10 minutes, Where as the same query which is executed here in our development servers is retrieving 1300 odd records in less than 4 minutes.

I checked the client place for Indexes and rebuilt all the indexes as the tables that were used were major tables. I also had a look into...