estimate and warning before executing query
- From: "Eric Buddelmeijer" <Eric.Buddelmeijer@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 14 Mar 2005 15:04:10 +0100
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
L.S.,
=20
We currently have an DBMS that estimates the cost of a query. If the =
cost is
higher than a certain value the DBMS itself returns an error stating the
query is too expensive. Cursing in the church (list) of course, but this
ingres. The query is not executed actually. The query optimizer itself
creates a plan and checks the cost. When too high it gives the signal. =
Is a
lot faster than any solution using something like rownum < value, =
especially
with ordered queries. Is there such a threshold in oracle that can be =
set
with the same benefits:
- early warning of 'costly' queries
- doing only optimizing for the query
=20
Looking for handles to start digging.
=20
TIA,=20
Eric Buddelmeijer=20
DBA=20
e-mail Eric.Buddelmeijer@xxxxxxxxxx=20
"Thou shallst be critical towards advice of guru's"
(From "Commandments (10) for better database design" by Ren=E9 Veldwijk) =
Dit bericht en alle eventueel meegestuurde documenten zijn vertrouwelijk =
en
alleen bestemd voor degene aan wie het bericht geadresseerd is. Indien u =
dit
bericht heeft ontvangen terwijl u niet de geadresseerde bent, verzoeken =
wij
u het bericht te vernietigen en ons daarvan in kennis te stellen. Dit
bericht is tevens gecontroleerd op computervirussen. =20
This e-mail and any files transmitted with it are confidential and =
intended
solely for the use of the individual or entity to whom they are =
addressed.
If you have received this e-mail in error, please delete the message and
notify us. This e-mail message has been swept by MIMEsweeper for the
presence of computer viruses
. =20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
