Protect against the query from hell ?
From: Ferdinand Swaters <ferd_at_incore.xs4all.NO_SPAM.nl>
Date: Wed, 2 Jun 1999 12:04:34 +0200
Message-ID: <7j3198$f09_at_guust.incore.xs4all.nl>
Hi all,
Date: Wed, 2 Jun 1999 12:04:34 +0200
Message-ID: <7j3198$f09_at_guust.incore.xs4all.nl>
Hi all,
In a database system I'm currently designing, users can place ad-hoc queries on a huge set of data. A small error in the query may result in a query from hell, one that runs almost forever or returns several terabytes of data. The superlarge output result can easily be solved by a limiting clause on ROWNUM, but how about runtime?
Is there a way to limit the runtime of a query, so that it can abort when the runtime is extremely long?
advTHANKSance,
Ferdinand Swaters