When i run a query its taking 2 min trough a java app we developed -- 1.30 in Sql assistant to display rec..But intrestingly its just 60 millisec when we check in DBQLOG time
Any idea why this huge difference is coming???
DBQLOG is showing time the Teradata server took to process the request, Whil the time shown in application and SQL Assistant includes the time of data transfer over ODBC OR JDBC over the network. I think that is causing the time difference between these measurements.
Thanks Khurram,,I guessed it,,,But will it be such so huge difference