Re[4]: oracle can ignore hints
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: Mark Leith <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Mar 2004 10:40:33 -0500
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@xxxxxxxxxxx
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@xxxxxxxxxxx and
include the word "subscribe" in either the subject or body.
Monday, March 15, 2004, 9:05:01 AM, Mark Leith (mark@xxxxxxxxxxxxxxxx) 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 be
ML> 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@xxxxxxxxxxxxxxxx
ML> http://www.cool-tools.co.uk
ML> -----Original Message-----
ML> From: oracle-l-bounce@xxxxxxxxxxxxx
ML> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ryan.gaffuri@xxxxxxx
ML> Sent: 15 March 2004 13:19
ML> To: oracle-l@xxxxxxxxxxxxx; Niall Litchfield
ML> Subject: Re: Re[2]: oracle can ignore hints
ML> embarcadero is one. I think quest's does the same thing.
>>
>> From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
>> Date: 2004/03/15 Mon AM 08:01:38 EST
>> To: Niall Litchfield <oracle-l@xxxxxxxxxxxxx>
>> Subject: Re[2]: oracle can ignore hints
>>
>> Monday, March 15, 2004, 4:12:55 AM, Niall Litchfield
>> (n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxx
>>
>> 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@xxxxxxxxxxx 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@xxxxxxxxxxxxx put
>> 'unsubscribe' in the subject line.
>> --
>> Archives are at //www.freelists.org/archives/oracle-l/
>> FAQ is at //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@xxxxxxxxxxxxx put
ML> 'unsubscribe' in the subject line.
ML> --
ML> Archives are at //www.freelists.org/archives/oracle-l/
ML> FAQ is at //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@xxxxxxxxxxxxx
ML> put 'unsubscribe' in the subject line.
ML> --
ML> Archives are at //www.freelists.org/archives/oracle-l/
ML> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
ML> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
