|
You are here |
jonathanlewis.wordpress.com | ||
| | | | |
tonyhasler.wordpress.com
|
|
| | | | | When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my... | |
| | | | |
hourim.wordpress.com
|
|
| | | | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | |
| | | | |
afatkulin.blogspot.com
|
|
| | | | | 11G's ability to do direct path reads during full table scans without utilizing PQ was covered in a number of places already (see this post ... | |
| | | | |
dbanuggets.com
|
|
| | | Thanks to Kevin Chant for inviting us to write this month's T-SQL Tuesday. This month is special, as Kevin mentioned due to the Festive Tech Calendar, which I have been speaking about for a couple of years now. Every day of the December month, a new recording or a blog post will be released for... | ||