Explore >> Select a destination
|
You are here 
|
akorotkov.github.io | ||
| | | | |
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... | |
| | | | |
nenadnoveljic.com
|
|
| | | | | A frequently executed SQL causes problems with the initial incremental statistics calculation. | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | A couple of weeks ago, having just arrived home from Spain, I got a phone call in Heathrow airport from an old client that I hadn't seen for about 18 months. They had a problem; as far as they could tell a business critical query had suddenly stopped using an index and was doing a... | |
| | | | |
hourim.wordpress.com
|
|
| | | I like very much Tanel Poder snapper and Carlos Sierra SQLTXPLAIN. They represent valuable performance diagnostic tools. Unfortunately I am still waiting to find a customer site where I will be allowed or granted necessary privileges to install and to use them. There are client sites where I have been asked to tune queries without... | ||
