Joe Celko’s review of my book SQL Performance Explained was just published. The bottom line: “This book is definitively worth having in the company library.”
Original title and author: “Joe Celko’s review of “SQL Performance Explained”” by Markus Winand.
Todays installment covers delete performance. It is similar, yet different, than insert performance covered last week.
Todays installment opens the—for the time being—last chapter in Use The Index, Luke. After spending a year and a half writing about the benefits of proper indexing, I have, of course, also tell you about the dark side of indexes. That is insert, update and delete performance.
After the very short chapter intro, todays installment shows you the indexing impact on insert statement.
Todays installment continues the Chapter about efficiently fetching partial results—that is, whenever you don’t need all the rows. Todays part explains how to fetch the next page efficiently.
Todays installment opens the Chapter about efficiently fetching partial results—that is, whenever you don’t need all the rows, but just a few from the beginning. These kind of queries are every often used to show lists in a page wise manner.
The installment consists of two parts: the chapter intro and the first section about the Top-N queries.
Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com