/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

 ottertune.com
Run ANALYZE. Run ANALYZE. Run ANALYZE. | OtterTune
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins
4.6 parsecs away

Travel
| | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.
| | phiresky.github.io
Using PostgreSQL production query planner statistics to fill a mock database - phiresky's blog
2.6 parsecs away

Travel
| | Did you know that PostgreSQL stores statistics about your data that can also be pretty useful not just for the query planner? Say you have a table users (id bigint, created timestamptz, category text): This information is a bit hard to interpret, so let's just let AI give us a nice visualization of
| | ankane.org
Introducing Dexter, the Automatic Indexer forPostgres
3.7 parsecs away

Travel
| | Your database knows which queries are running. It also has a pretty good idea of which indexes are best for a given query. And since indexes don't...
| | tonyhasler.wordpress.com
FORCE_MATCH for Stored Outlines and/or SQL Baselines? | Tony's Oracle Tips
18.2 parsecs away

Travel
| Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...