Date: 14th November 2007
I am Chandrajit Samanta, working in a product based s/w org (Metrica Systems Pvt. Ltd.) in Bangalore. We are using SQL Server 2000, C#, ASP.NET for our product. My work is mainly database intensive. Frequently I have to deal with heterogeneous database environment like Informix, Oracle, Sql Server simultaniously.
I have to fetch records from Informix, oracle database to our SQL Server Database. For which I have to create several DTS.
But the problem is, original tables (Informix,Oracle) has billions of records. For that to run one simple query like (Select * from Table_name where dtDate > '2007-11-01 17:00:00.000') in DTS it tooks 25min - 35min time.
We have only "Read Only " access i.e. select priviledge to all those (Informix,Oracle) database.
Please tell me how to improve such query so that this query running time is minimized.
I am waiting for your response.