| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: oracle can ignore hints
Jonathan - are you referring to SQLExpert? This tool does in fact
re-write a given piece of SQL in every semantically equivalent way that
is possible (including hints, rewriting the code semantics etc.) - then
shows you all of the re-written statements that have an alternate
execution plan to the source SQL for benchmarking..
I'm pretty sure that no other SQL tuner in the market does this quite like SQLExpert (please correct me if I'm wrong - I don’t get the chance to test out new versions of competitors products lately, and they may be catching up with SQLExpert - which has been doing tuning this way since first release..).
The vendor is Leccotech by the way - we are a UK distributor.
Mark
Mark Leith
Cool-Tools UK Limited
Tel: 01905 330 281
Fax: 08701 275 283
mark_at_cool-tools.co.uk
http://www.cool-tools.co.uk
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan.gaffuri_at_cox.net
Sent: 15 March 2004 13:19
To: oracle-l_at_freelists.org; Niall Litchfield
Subject: Re: Re[2]: oracle can ignore hints
embarcadero is one. I think quest's does the same thing.
>
> From: Jonathan Gennick <jonathan_at_gennick.com>
> Date: 2004/03/15 Mon AM 08:01:38 EST
> To: Niall Litchfield <oracle-l_at_freelists.org>
> Subject: Re[2]: oracle can ignore hints
>
> Monday, March 15, 2004, 4:12:55 AM, Niall Litchfield
> (n-litchfield_at_audit-commission.gov.uk) wrote:
> NL> Stated like this it is obvious that most tuning efforts are at
> NL> best wasteful of effort (and indeed could probably be done better
> NL> by software which is great at trying hundreds or thousands of
> NL> possibilities in a scattergun approach).
>
> I have seen such software. I don't recall the vendor at the moment,
> but that software exists. You can probably see it demoed at the next
> OracleWorld.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to Oracle-article-request_at_gennick.com and
> include the word "subscribe" in either the subject or body.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org put
> 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Mar 15 2004 - 07:59:24 CST
 |
 |