on 03-10-2010 8:12 AM
Hi,
I want to use the option "Warn if cost estimation exceed" in the control tab of universe parameters.
This option is always greyed out.
Is this option database specific?
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
this option works only with Teradata. It is the only database which returns a cost estimate in a time format. Other database return it in cycles or other measures which cannot be easily transformed in a useful information.
Best regards
PPaolo
Thanks for the reply.
I want to use it for sql server2005.
My requirement is to kill the execution of a query at database end if it takes more than a stipulated time.
For eg. If I want any query to run not more than 15 mins at db end.
I can make use of hint "query governor cost limit" in Begin_SQL but its not working with Oledb, it works only with ODBC.
Any suggestion.
In the universe parameters there is a tab called controls, There you get the option to set the max execution
time for the query in seconds under "Limit execution time"
Rohit
Hi Rohit,
This doesnot kills the query at DB level.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.