| 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[4]: oracle can ignore hints
Hello Mark,
Yep. SQLExpert. Leccotech. That sounds about right. That's the tool I've seen demoed.
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.
Monday, March 15, 2004, 9:05:01 AM, Mark Leith (mark_at_cool-tools.co.uk) wrote:
ML> Jonathan - are you referring to SQLExpert? This tool does in fact ML> re-write a given piece of SQL in every semantically equivalent way that ML> is possible (including hints, rewriting the code semantics etc.) - then ML> shows you all of the re-written statements that have an alternate ML> execution plan to the source SQL for benchmarking.. ML> I'm pretty sure that no other SQL tuner in the market does this quite ML> like SQLExpert (please correct me if I'm wrong - I don’t get the chance ML> to test out new versions of competitors products lately, and they may beML> catching up with SQLExpert - which has been doing tuning this way since ML> first release..).
ML> The vendor is Leccotech by the way - we are a UK distributor.
ML> Mark
ML> Mark Leith
ML> Cool-Tools UK Limited
ML> Tel: 01905 330 281 ML> Fax: 08701 275 283 ML> mark_at_cool-tools.co.uk ML> http://www.cool-tools.co.uk ML> -----Original Message----- ML> From: oracle-l-bounce_at_freelists.org ML> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan.gaffuri_at_cox.net ML> Sent: 15 March 2004 13:19
ML> 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
ML> 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
>> -----------------------------------------------------------------
>>
ML> ---------------------------------------------------------------- ML> Please see the official ORACLE-L FAQ: http://www.orafaq.com ML> ---------------------------------------------------------------- ML> To unsubscribe send email to: oracle-l-request_at_freelists.org put ML> 'unsubscribe' in the subject line. ML> -- ML> Archives are at http://www.freelists.org/archives/oracle-l/ML> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
ML> ----------------------------------------------------------------- ML> --- ML> Incoming mail is certified Virus Free.ML> Checked by AVG anti-virus system (http://www.grisoft.com). ML> Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004
ML> --- ML> Outgoing mail is certified Virus Free. ML> Checked by AVG anti-virus system (http://www.grisoft.com). ML> Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004 ML> ---------------------------------------------------------------- ML> Please see the official ORACLE-L FAQ: http://www.orafaq.com ML> ---------------------------------------------------------------- ML> To unsubscribe send email to: oracle-l-request_at_freelists.org ML> put 'unsubscribe' in the subject line. ML> -- ML> Archives are at http://www.freelists.org/archives/oracle-l/ML> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
ML> ----------------------------------------------------------------- ----------------------------------------------------------------Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 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 - 09:37:03 CST
 |
 |