tuning basics [message #629594] |
Thu, 11 December 2014 11:29 |
|
m.abdulhaq
Messages: 254 Registered: April 2013 Location: Ajman
|
Senior Member |
|
|
hi experts , kindly suggest me how can i gain more knowledge on performance tuning as i have to fine tune , lot of long running queries in my database.Do i need to start from Database concepts , then performance tuning guide .
|
|
|
|
|
Re: tuning basics [message #629638 is a reply to message #629630] |
Fri, 12 December 2014 16:23 |
|
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
If what you are looking for is SQL Tuning, then attached is the first chapter of my book on SQL Tuning. This is the promotional chapter, but it is the full chapter so you can learn about the FRP method of Cardinality Based Tuning. The scripts from the book are also free regardless of if have the book or not, and can be downloaded from here.
If you like what you read, you can buy the book at a discount because you are a member of ORAFAQ. The link shows the 50% off coupon code but through end of December, you can also use this 60% off code. These codes are only good on the CREATESPACE website.
ZK9SXEMX Percentage Off 60%
To be clear, the first chapter and the scripts are free. You do not have to purchase the book to take them.
Enjoy. Kevin Meade
[Updated on: Mon, 05 January 2015 16:55] Report message to a moderator
|
|
|