Re: Re[4]: oracle can ignore hints
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 15 Mar 2004 11:07:22 -0500
what did you think of sqlexpert?
>
> From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
> Date: 2004/03/15 Mon AM 10:40:33 EST
> To: Mark Leith <oracle-l@xxxxxxxxxxxxx>
> Subject: 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@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
> -----------------------------------------------------------------
>
----------------------------------------------------------------
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:
