Explore >> Select a destination
|
You are here 
|
antognini.ch | ||
| | | | |
36chambers.wordpress.com
|
|
| | | | | This is part seven in a series on window functions in SQL Server. The Road So Far To this point, we've looked at five classes of window function in SQL Server. I've given you a couple of solid use cases, but for the most part, we've focused on what the classes of window functions are.... | |
| | | | |
dincosman.com
|
|
| | | | | The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter.... | |
| | | | |
dioncho.wordpress.com
|
|
| | | | | One of the customers complained that Oracle refuses to use the HASH GROUP BY operation under any circumstances. It's 10gR2(10.2.0.1) database. See that Oracle simply refuses to use HASH GROUP BY operation even with the simplest group by? You might think that the "_gby_hash_aggregation_enabled" would have been false which is clearly right. But even with... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | Okay, so the title is pretentious; but I thought it was a snappy summary of this item [until someone pointed out that Heisenberg's Uncertainty Principle is not about measurement error]. I've blogged before about the improved features in 10g of the dbms_xplan package, in particular the display_cursor() procedure, with its option for displaying rowsource execution... | ||
