Query performance in SQL and BTEQ

Tools
Enthusiast

Query performance in SQL and BTEQ

Hi all,
What is the differenece between the query performance in SQL assistant and BTEQ.i observed a significant improvement in performance of a query in BTEQ compared to when run in SQL assistant.Is there any specific reason for this.

Thanks and Regards
Sreehari
2 REPLIES
Fan

Re: Query performance in SQL and BTEQ

Hi Sreehari

SQL Assistant connects to the database via ODBC, so many of the performance observations may be due to limitations with ODBC itself.

BTEQ doesn't connect via ODBC, instead it effectively uses teradata's own API's to connect (effectively a "direct connection"). I can't remember the exact jargon at the moment.

Hope that helps.
Tim
Enthusiast

Re: Query performance in SQL and BTEQ

hi Tim thanks a lot....
do you meant CLI(client level interface)