Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does the tool allow the user to limit execution time, cancel at any time, limit rows returned, and specify estimated time to generate information?

April 26, 2017cancel execution limit RETURNED rows specify time Tool user

0

Posted

Does the tool allow the user to limit execution time, cancel at any time, limit rows returned, and specify estimated time to generate information?

1 Answer

0

Posted

Yes. The ODBC & OLE-DB Specifications permit users to limit query execution times (Query Timeout), and limit the number of rows returned. Currently, CONNX does not return a “time estimate” for query execution. However, CONNX can return a “query execution plan”, which describes how CONNX will attempt process a query.