DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: LECCO sql expert - opinions?

  1. #1
    Join Date
    Jul 2003
    Location
    Sofia, Bulgaria
    Posts
    91

    LECCO sql expert - opinions?

    What do you think about that software? I am using it for couple of days for query tuning and it is absolutely perfect (It rewrites the problematic query in all possible ways, also using hints, etc and that it can execute all of them and will give time for execution and all statistics.). I heard QUEST have something similar, had anybody used it?
    Share your opinions on those kind of products pls.

  2. #2
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    The QUEST product is TOAD.It has great DBA functionalities and is easy to use if you know what a DBA is actually suppose to do...

    Check the Oracle mag for adds on DBA/DEV tools if you can...
    Able was I ere I saw Elba

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    I have dabbled with Lecco quite a bit and it is excellent for SQL tuning. Usually I will use OEM to look at the top 10, and then use Lecco to re-write. Very powerfull tool, not the most user friendly but there are a lot of options.

    I have never used Toad.

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    About 5 years ago I played with Quest SQLab or SQLExpert (or some name like that). You could grab queries from the pool and it would propose tuning improvements. I decided it was much too expensive for my use.
    http://www.quest.com/quest_central/oracle/sql_tuning/

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Wil these tools handle analytic functions, or subquery factoring clauses?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134
    Originally posted by slimdave
    Wil these tools handle analytic functions, or subquery factoring clauses?
    Good question, check http://www.leccotech.com/

    Look at SQL expert for Oracle, you can download a free trial.
    Try before you buy.

    MH

    Ps. I just dropped tech support an E-mail with your question, I'll post the results when I get them.
    Last edited by Mr.Hanky; 02-25-2004 at 12:15 PM.
    I remember when this place was cool.

  7. #7
    Join Date
    Jan 2001
    Posts
    3,134
    From Leccotech....

    "Yes, LECCO SQL Expert handles analytic functions (support available since version 3.3.0) and subquery clauses.
    The latest version of LECCO SQL Expert for Oracle is version 3.7.0.
    "

    MH
    I remember when this place was cool.

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by Mr.Hanky
    From Leccotech....

    "Yes, LECCO SQL Expert handles analytic functions (support available since version 3.3.0) and subquery clauses.
    The latest version of LECCO SQL Expert for Oracle is version 3.7.0.
    "

    MH
    Were they talking about subqueries, or "subquery factoring" clauses (WITH clauses), do you know?

    I'm wondering if you gave the tool a query that would perform better with an analytic function or with a WITH clause, would it take steps to convert it and test? It seems like that could be quite a technical challenge.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width