Explore >> Select a destination
|
You are here 
|
tanelpoder.com | ||
| | | | |
sqlmaria.com
|
|
| | | | | When diagnosing and correcting a performance regression for a SQL statement, it can often be challenging to find out what is happening during the execution and why your corrective measures are not ... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | I've discussed the capabilities of the dbms_xplan package in a couple of posts already; and shown how useful it can be in two examples: understanding a problem with filter subquery selectivity and understanding why some Cartesian merge joins were appearing unexpectedly. Let me make a crucial point about execution plans (again): if you have a... | |
| | | | |
blog.tanelpoder.com
|
|
| | | | | Despite the title, this is actually a technical postabout Oracle, disk I/O and Exadata & Oracle In-Memory Database Optionperformance. Read on :) If a car dealertells you that this fancy new car on display goes 10 times (or 100 or 1000) faster than any of your previous ones, then either the salesman is lying or this new car is doing something radically differentfrom all the old ones. You don't just get orders of magnitude performance improvements by making small changes. Perhaps the car bends space around... | |
| | | | |
blobeater.blog
|
|
| | | I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself as I found a way to get a time based on a geographic region. This new feature is available to you from SQL 2016 which obviously means SQL database too (Azure). It is called AT... | ||
