blog.tanelpoder.com/2013/03/20/alter-session-force-parallel-query-doesnt-really-force-anything

Preview meta tags from the blog.tanelpoder.com website.

Linked Hostnames

9

Search Engine Appearance

Google

https://blog.tanelpoder.com/2013/03/20/alter-session-force-parallel-query-doesnt-really-force-anything

Alter session force parallel query doesn’t really force anything - Tanel Poder Consulting

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. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.



Bing

Alter session force parallel query doesn’t really force anything - Tanel Poder Consulting

https://blog.tanelpoder.com/2013/03/20/alter-session-force-parallel-query-doesnt-really-force-anything

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. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.



DuckDuckGo

https://blog.tanelpoder.com/2013/03/20/alter-session-force-parallel-query-doesnt-really-force-anything

Alter session force parallel query doesn’t really force anything - Tanel Poder Consulting

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. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • General Meta Tags

    7
    • title
      Alter session force parallel query doesn’t really force anything | Tanel Poder Consulting
    • charset
      utf-8
    • viewport
      width=device-width, initial-scale=1
    • msapplication-TileColor
      #da532c
    • theme-color
      #ffffff

  • Open Graph Meta Tags

    2
    • og:title
      Alter session force parallel query doesn’t really force anything - Tanel Poder Consulting
    • og:description
      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. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • Twitter Meta Tags

    2
    • twitter:title
      Alter session force parallel query doesn’t really force anything - Tanel Poder Consulting
    • twitter:description
      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. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • Item Prop Meta Tags

    1
    • description
      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. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.

  • Link Tags

    5
    • apple-touch-icon
      /apple-touch-icon.png
    • icon
      /favicon-32x32.png
    • icon
      /favicon-16x16.png
    • manifest
      /site.webmanifest
    • mask-icon
      /safari-pinned-tab.svg

Links

19