Explore >> Select a destination
|
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... | |
| | | | |
tanelpoder.com
|
|
| | | | | As I promised in my previous post, I'm going to blog more frequently for a change. So here's a blog entry about some "new" Oracle execution plan displaying scripts that I've had since 2011 or so - I just tidied them up recently and added some improvements too. My aim in this blog post is not to go deep into SQL tuning topics, but just show what these scripts can do. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | |
| | | | |
www.brentozar.com
|
|
| | | I know this is going to come as a stunning shock to you, dear reader, so you may want to be sitting down. SQL Server isn't perfect. It's okay. Deep, calming breaths. We're going to get through this together, and here's how: Go to Connect.Microsoft.com, the place where we file bug reports and enhancement requests... | ||
