Analyze Query Software

Discussion in 'Databases' started by deriklogov, Jul 6, 2009.

0
  1. #1
    Is there any software which could analyze and optimize queries ?
     
    deriklogov, Jul 6, 2009 IP
  2. winwebeuk

    winwebeuk Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Well optimization is a skill of a DBA :)
    A tool can not optimize any database like a DBA.
    It involves database normalization, rearranging schemas, proper use of WHERE and JOIN clauses etc.
    normalization to 3rd form is the best practice. SPs are normally faster than queries hence its better to arrange queries in SPs.
     
    winwebeuk, Jul 6, 2009 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    no, optimization is a hard task :)
     
    gibex, Jul 7, 2009 IP
  4. nvidura

    nvidura Well-Known Member

    Messages:
    1,780
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    150
    #4
    Use a persistent layer in your programming architecture. You can find tons of Free and Open Source Software in the Internet...
     
    nvidura, Jul 16, 2009 IP