/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.darwinweb.net
In Defense of ORMs
| | korban.net
The case against ORMs | Korban.net
3.8 parsecs away

Travel
| |
| | questdb.io
Running Databases on Kubernetes
3.8 parsecs away

Travel
| | Things to consider when running a database on Kubernetes.
| | www.scattered-thoughts.net
Unexplanations: sql is syntactic sugar for relational algebra
3.6 parsecs away

Travel
| |
| | tanelpoder.com
Alter session force parallel query doesn't really force anything | Tanel Poder Blog
21.6 parsecs away

Travel
| Jonathan Lewis has already written about this behavior from the angle of PARALLEL hints. I'm writing a similar article just because the word FORCE in the ALTER SESSION FORCE PARALLEL QUERY syntax. Force should mean that some behavior would always happen (when possible), right? Let's test: SQL> CREATE TABLE t AS SELECT * FROM dba_objects; Table created. SQL> CREATE INDEX i ON t(owner); Index created. SQL> @gts t Gather Table Statistics for table t... PL/SQL procedure successfully completed. Now let's "force" the parallel query in my session, run the query and check the execution plan: - Linux, Oracle, SQL performance tuning and troubleshooting training & writing.