Professional Web Applications Themes

tuning SQL - IBM DB2

Can anyone recommend a good web site that details effective SQL tuning? I'm a programmer, not a DBA. Therefore I'm looking at this more from an application perspective. Also any good books not specific to any one database?...

  1. #1

    Default tuning SQL

    Can anyone recommend a good web site that details effective SQL
    tuning? I'm a programmer, not a DBA. Therefore I'm looking at this
    more from an application perspective.

    Also any good books not specific to any one database?
    mike Guest

  2. #2

    Default Re: tuning SQL


    Good book :

    SQL Performance Tuning by P Gulutzan
    ISBN: 0201791692

    Cheers

    Sathyaram


    Originally posted by Mike
    > Can anyone recommend a good web site that details effective SQL
    > tuning? I'm a programmer, not a DBA. Therefore I'm looking at this
    > more from an application perspective.
    >
    Also any good books not specific to any one database?

    --
    DB2 discussion also at [url]http://www.dbforums.com/f8[/url]


    Posted via [url]http://dbforums.com[/url]
    sathyaram_s Guest

  3. #3

    Default Re: tuning SQL

    The basics of SQL tuning apply to all DBs. Grad a book on optimizing SQL.
    Then start the DB2 Command Center, type out some SQL and go to Script |
    Create Access Plan. The Access Plan will tell you how the DB will execute
    your command. Just looking at the execution flow you usally can figure out
    how to optimize the statement. ...it's a start.

    "mike" <arar0344532hrkrtowyahoo.ca> wrote in message
    news:JdgMPzmh2mGXswLq=2Jyiz+X03lK4ax.com...
    > Can anyone recommend a good web site that details effective SQL
    > tuning? I'm a programmer, not a DBA. Therefore I'm looking at this
    > more from an application perspective.
    >
    > Also any good books not specific to any one database?

    Brien Schultz Guest

Similar Threads

  1. chip tuning
    By chip tuning in forum Macromedia Dynamic HTML
    Replies: 6
    Last Post: June 16th, 06:28 PM
  2. SE 5 tuning/optimizing on SCO
    By Franz Grützmacher in forum Informix
    Replies: 3
    Last Post: November 6th, 07:51 AM
  3. SQL Tuning
    By Kota in forum IBM DB2
    Replies: 0
    Last Post: July 1st, 10:05 PM
  4. intro to tuning?
    By Petee in forum Oracle Server
    Replies: 10
    Last Post: June 27th, 01:10 PM
  5. Tuning Question
    By Burton Peltier in forum Oracle Server
    Replies: 5
    Last Post: June 26th, 03:32 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139