/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

 blog.jooq.org
How to Write a Multiplication Aggregate Function in SQL Java, SQL and jOOQ.
| | xnacly.me
Improving programming language performance | xnacly - blog
15.7 parsecs away

Travel
| | Reducing the execution time of a benchmark by 85% or 7.03x
| | blog.sqlterritory.com
SQL Graph Database - the new feature in SQL Server 2017 - SQLTerritory.com
16.0 parsecs away

Travel
| | SQL Server 2017 introduced a lot of new features. One of the most surprising is Graph Database capabilities (aka SQL Graph and Graph Extensions). This new functionality enables users to model complex relationships using new database objects and queries. Let's see what it is and how it works. What are Graph Databases? In general, Graph ... Continue reading "SQL Graph Database - the new feature in SQL Server 2017"
| | nenadnoveljic.com
Performance Problem with Incremental Statistics Calculation - All-round Database Topics
14.3 parsecs away

Travel
| | A frequently executed SQL causes problems with the initial incremental statistics calculation.
| | jonathanlewis.wordpress.com
use_nl hint | Oracle Scratchpad
34.5 parsecs away

Travel
| In response to a recent lamentation from Richard Foote about the degree of ignorance regarding the clustering_factor of indexes I commented on the similar degree of ignorance regarding the syntax of a specific hint, namely use_nl(a b), pointing out that this does not mean "do a nested loop from a to b". My comment was...