Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL tuning
- Thread starter anandcv
- Start date
SantaMufasa
Technical User
Anand,
SQL Tuning is the process by which we can modify the characteristics of the Oracle instance, the database, individual tables (and/or indexes), or code (SQL and/or PL/SQL) to improve the performance of an application.
There is a growing cadre of automated tools that can assist, but still the best method to improve tuning is your knowledge. A great tuning book that I highly recommend is "SQL Tuning" by Dan Tow, published by O'Reilly. The book covers Oracle, DB2, and SQL Server. It is available via Amazon.com.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 16:34 (13Jul04) UTC (aka "GMT" and "Zulu"), 09:34 (13Jul04) Mountain Time)
SQL Tuning is the process by which we can modify the characteristics of the Oracle instance, the database, individual tables (and/or indexes), or code (SQL and/or PL/SQL) to improve the performance of an application.
There is a growing cadre of automated tools that can assist, but still the best method to improve tuning is your knowledge. A great tuning book that I highly recommend is "SQL Tuning" by Dan Tow, published by O'Reilly. The book covers Oracle, DB2, and SQL Server. It is available via Amazon.com.
Mufasa(aka Dave of Sandy, Utah, USA @ 16:34 (13Jul04) UTC (aka "GMT" and "Zulu"), 09:34 (13Jul04) Mountain Time)
- Status
