/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 www.dbaglobe.com
Donghua's Blog - DBAGlobe: Performance Tuning using Windowing Aggregate Functions to avoid table self-join
| | savvinov.com
Reading SQL plans - Oracle Diagnostician
1.3 parsecs away

Travel
| | SQL tuning is the key to database performance tuning, and yet this seems to be a "blind spot" for many database specialists. I think it's probably because it falls right on the boundary between DBA's and developer's responsibilities: so while a DBA expects database developers take care of performance while developing code, developers often neglect...
| | leonotes.wordpress.com
(transitive closure)?(Constraint-Generated Predicates) | LEO Notes
1.6 parsecs away

Travel
| | transitive closure?Wiki?Oracle?...
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
1.6 parsecs away

Travel
| | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...
| | carlos-sierra.net
SQLTXPLAIN 101 | Carlos Sierra's Tools and Tips
13.9 parsecs away

Travel
| SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1. Q: What do you get from this tool? A: In...