Blog

Todays installment covers update performance. As slow as insert and delete together, but sometimes still faster.

Continue Reading

Todays installment covers delete performance. It is similar, yet different, than insert performance covered last week.

Continue Reading

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.

Continue Reading

Todays installment finalizes the Chapter on partial results and shows how to use SQL:2003 window-Functions for an offset-based pagination query in SQL Server and Oracle.

Continue Reading

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.

Continue Reading

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.

Continue Reading

Todays update delivers the last part of the Chapter on sorting and grouping. It is a short demonstration how to use indexing for a pipelined group by.

Pipelined order by and group by are the prerequisite for the optimization methods described in the next chapter on partial results.

Besides that, you should definitely have a look a my new website.

My New Website

Read Group By Article

Todays update explains how to control the index order so that queries using ASC/DESC or NULLS FIRST/LAST specifications can also be executed as piplined order by.

Continue Reading

Todays installment is about the third power of indexing: satisfying order by clauses by an index—thus, preventing the need to sort the data.

The installment consists of two parts: the chapter intro and the first section about the interactions between the order by and the where clause.

Continue Reading

The previous installment explained the index-only scan to prevent the table access after an index lookup.

Todays update extends the idea and elaborates on the question if the separate table structure is required at all, if the index covers all table columns.

Continue Reading